Cross Sheet References
Cross Sheet References where reference is Sheet A and being pulled from Sheet B, does the Cross sheet Reference count in Sheet A or B?
I have sheets which are grinding to a halt and would like to know which aspect is being overloaded.
Sheet is 5000 rows, 36 columns. We have Cross sheet References and formulas
i see tha limits are:
Available on all plan types, sheets now support up to 20,000 rows, 400 columns, 500,000 cells, 100,000 cross-sheet cell references, and 20,000 cell links. In addition, users will see up to 2x faster load times and up to 6x faster sheet scrolling.
Im not hitting Row or Column or Cell limits.
Am i htting Cross Sheet Reference limits where each row
The Sheet References Manager on Sheet A does not show any Cross Sheet References. I assume this is because the reference is formulated on Sheet B to look at Sheet A?
My tests seem to indicate that if on Sheet A i remove the Cross Sheet Reference, the sheet starts to operate. This would indicate that Cross Sheet References
is there a non Cross Sheet Reference formula limit?
Help Article Resources
Check out the Formula Handbook template!