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).

7 Upvotes

33 comments sorted by

View all comments

2

u/NinjaBear95 1 21d ago

Ugh, it's so frustrating when updates break our tools instead of improving them!

1

u/gk802 21d ago

Agree, but I have learned two new Excel skills, now... how to revert to a prior version and how to turn off automatic updates.