Cross-sheet reference maximum?
Hello! I received an error when I was working on one of my sheets that says:
"Unable to create cross-sheet reference, because this sheet already contains the maximum umber of different cross-sheet references."
This is the first time I've see it, the sheet it happened on is a dashboard metrics sheet that pulls from several different sheets different values. Is there a limit I didn't know about? What can I do to work around this?
For context, the sheet of metrics has a list of all the clinics we have (48) and each has two values that we're pulling with a formula (=value and =countif) from it's respective sheet.
Answers
-
Hi
The limit is 100. So if you have 48x2 you would be very close to that limit. You may have a couple that you are not using (right click and select Manage References). Deleting those that aren't in use could unblock things for now but won't allow any wiggle room to add any more data or clinics in the future.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!