Forum Discussion

Europaul's avatar
Europaul
Copper Contributor
Apr 04, 2021
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...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Apr 04, 2021

    Europaul 

    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.

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Apr 07, 2021
It would be best if you could buy them all and use them all on one PC, depending on what you need.
Until a clear path has crystallized, some time will pass.
I will wait in advance for the 2021 and in the meantime experiment with online ... I can load that on the PC with my existing Excel.

Interesting things will come our way ... it's nice to live in this time.

Thanks for the summary - info 🙂
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 07, 2021

NikolinoDE 

That's limited only by amount of money you are ready to spend. You may use virtual machine with branches and install as many versions as you wish, using main version of Office on main OS. 

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Apr 07, 2021
    Something like that is sure to come, wait for the first quantum computer ... then I'll step on the gas :)))

    I wish all of us have a good day 🙂

Resources