100,000 cell reference limit - do I understand it right and can I monitor it?
Answers
-
The columns being added in the sum formula are ALL data entry. Which is why I am unable to understand where the 25 mil is coming from.
-
Hi @Gita Mooney
Thanks for clarifying. Are you referencing this sheet in other sheets?
The total count of cells referenced by formulas in a sheet cannot exceed 25 million. This includes cross-sheet references, in-sheet cell references, column references, and range references. However, only cells that contain formulas are counted towards the limit.
If this hasn't helped, please do connect with Support as you can then share your sheet and go through each individual column to identify where the references are hitting the limit.
Cheers,
GenevieveNeed more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives