There are too many cells referenced by formulas in this sheet
Hi,
I get this message "There are too many cells referenced by formulas in this sheet" every time I load a specific sheet.
Then the sheet disappears & Chrome leaves this message: Aw, Snap, Error code: Out of Memory
Would anyone have an idea how to tackle this ?
I'll try to clean Chrome temporary files to get more available memory.
Are there best practices to reduce the memory countifs use ?
Are Datameshs more memory savvy than vlookups ?
Anything else I should think about ?
Thanks,
PierreEric
Best Answer

Thanks JKHALID. Indeed this is probably a good one.
Since I posted this question I came to use Datamesh much more that vlookups.
There are other downsides to this solution like losing benefit of instantaneous result.
But at least it much more efficient memorywise.
Answers

I hope you're well and safe!
What types of formulas do you have in it? How many columns/rows?
Be safe, and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hi Andrée,
Thanks for the answer.
The sheet has 32 columns, 2077 lines.
Formulas are countifs & vlookups
I've managed to copy/paste values 1 column worth of vlookup formulas but the problem remains.
The sheet gives me 10 seconds before it crashes
Any additional help would be very much welcome !
Thanks
PierreEric

First error message (Smartsheet):
5 seconds later webpage crashes & browser (Chrome or Edge) through this message:

Did you try replacing the vlookup formula with index/match? It is known to be more efficient than a vlookup.

Thanks JKHALID. Indeed this is probably a good one.
Since I posted this question I came to use Datamesh much more that vlookups.
There are other downsides to this solution like losing benefit of instantaneous result.
But at least it much more efficient memorywise.