Getting Max Allowed Cross Ref Error but only 64K cells cross referenced from other sheets
Greetings all,
I have a smartsheet with 16K rows. each row has 4 columns that have data referenced from other sheets. That should be a total of 64000 referenced from other sheets. However, I am still getting the "Some cross-sheet formulas can't be updated because this sheet has more cells referenced from other sheets then the maximum allowed (100000).
I have un-hid all columns to ensure there were not hidden references.
I also have 4 columns that are sending data to other sheets, but that does not seem applicable to the errors dialog since they are not From other sheets.
Does anyone know why I am getting this error?
Answers
-
How many unique cross sheet references have you built that point to that 64,000 cell sheet, and what are their ranges?
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!