r/excel 25d ago

Excel 365 Memory Issue solved

I have a fairly large spreadsheet with associated macros. It normally occupies about 300MB in memory, about 9MB on disk. After Excel's recent update to the latest current channel (Version 2408 (Build 17928.20114)), the spreadsheet immediately runs up to 4GB+ in the initial calculation process after opening and Excel crashes. Repair of the spreadsheet finds no errors. I reverted to Version 2407 (Build 17830.20166) and the spreadsheet has no issues. Curious if anyone else is experiencing a similar issue with the latest build.

Update: Testing in progress, but issue appears resolved with Version 2409 (Build 18025.20030).

6 Upvotes

33 comments sorted by

View all comments

1

u/SealedSeven 14d ago

There was an update yesterday, but nothing in the release that would appear to fix this issue. Anyone tried out the update?

1

u/gk802 14d ago

Update: I received the following email this morning (9/11/24):

Thank you for sending Microsoft feedback. Your input is valuable to us and helps improve our products.

Your feedback directly resulted in improvements to Office and we believe your issue has been addressed in the latest version of Office 365. Thank you! 

2

u/SealedSeven 14d ago

We're looking to give it a try here then. However takes awhile for some computers to see the latest update.

1

u/gk802 14d ago

Let me warn that the version I just updated is 2409 build 18025.20030, which I don't see the release notes for. I updated one win11 machine and it appears to be resolved. Will update a win10 machine next.

2

u/SealedSeven 14d ago

So latest beta build seems to be good.  That's good news that should be a fix soon officially. 

1

u/gk802 14d ago

I'm updating only in the release channel, so it must be official, but the notes are not updated yet.

1

u/SealedSeven 14d ago

I'm only seeing the version available in insiders channel, so hopefully pushed to live release soon. 

(2408 sept 10th update still current channel release shown)

1

u/gk802 14d ago

Added info. The release notes are in the "preview channel", but the updated loaded in the current channel. Notes are unspecific:

Version 2409: September 09

Version 2409 (Build 18025.20030)

  • Various bug and performance fixes.