Cross-sheet reference limit clarifications
We have a couple cross-sheet reference questions:
- Where can we see how close we are to the 25,000 cross-sheet reference and 5,000 cell-link limits? Also, is there a go-to link to these references?
- Clarification please: We have one Master Sheet and 3 other sheets that refer (pulls data from) the Master. Does the cross-sheet references limit of 25,000 cells refer to the number of times our supporting sheets refer back to (pulls data from) the Master? Or is it the other way around (i.e. the # of times the supporting sheets are referred to by the Master)?
- What about the above scenario (#2), as it relates to “A total of 100 distinct cross-sheet references can be created on a sheet.”
Hey! You will be signed out in 60 seconds due to inactivity. Click here to continue using the site.