Does "You can only reference a total of 100000 cells from other sheets." apply to 1 or all sheets
Options
Rich Stowell
✭✭✭✭✭
I have 2 sheets consolidating data from 2 source sheets. One of my consolidation sheets works fine, pulling data from both source sheets. The second consolidation sheet fails whenever I attempt to change the sheet reference in some cells to point to the second source sheet (which I was able to do on the first consolidating sheet without issue). I have changed over 90% of the reference formula's to static data on the 2nd consolidation sheet. but even that did not work.
How can I determine how many cell references are listed in a single sheet?
Answers
-
That is referring to inbound cells. So the sheet that is throwing the error is referencing too many cells from other sheets.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!