Forum Discussion
Solved
Slow updates
I have a spreadsheet with 3 tabs. I input data into 1 and it populates the other 2... Only 7 items get populated to one tab and 3 to the other, yet it takes over 30 secs for the 2 tabs to update - t...
An issue is in formula in cell N134 of Logbook
=SUMIF(A:A,">"&TODAY()-28*(E:E))Here for each cell in column A you use 1 million criteria (all cells in column E) to sum, thus formula makes 1M*1M = 1e12 calculations. After that it tries to return 1M results, but have not enough space for it and returns #SPILL error.
In previous versions of Excel silent implicit intersection mechanism worked in the background, formula calculated only for the criteria from current row.
Not sure what exactly you'd like to calculate, simply disabled the formula. Please check attached file if it is updated correctly.
For me, your file works without problems, quickly and does not hang anywhere.
Here is my suggested solution ...
File> Options> Advanced> Formulas> Use all processors on the computer: (click the radio button)
So it should actually be faster ... if it wasn't clicked 🙂
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Here is my suggested solution ...
File> Options> Advanced> Formulas> Use all processors on the computer: (click the radio button)
So it should actually be faster ... if it wasn't clicked 🙂
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.
Thanks Nikolino,
I already had that ticked... no improvement 😞
BR,
P
I already had that ticked... no improvement 😞
BR,
P
- Try this too:
Formulas> Name Manager
Delete all referenceless links
= #REFERENCE! #REFERENCE!
Especially the #REFERENCE! errors with links.
I hope that I could help you with this information / links.