Data Matrix for dashboard - cross sheet formulas
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading:
"Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from other sheets than the maximum allowed (25000)"
Currently I have 3 separate data matrix's to calculate this needed information on our dashboard. is there a way to get around this or will the limit on cells referenced ever be increased? I am getting "#Calculating" in all these cells.
Help Article Resources
Check out the Formula Handbook template!