I am building a Metrics sheet (for dashboard) using monthly data from 2024 and 2025 for two different divisions' data (2 different data sheets) that I need to add together in my metrics sheet. When I tried to link out to (cross reference) the data for company #2, I got the maximum cross-reference message.
I can't believe I reached the 25k limit. Even with each month's source data in separate sheets for each company, I've got about 1,000 links out in the formula sheet. Maybe more.
I've never hit a limit before…