r/excel • u/gk802 • 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

100% Upvoted

33 comments sorted by

View all comments

2

u/Economy_Ad9320 24d ago

Everything is the same, only I spent 3 days before I figured out to roll back the version. The maximum memory leak for me occurred on a sheet of 20,000 records when writing to VBA in 1 cell (Cells(x,y)="string" +10Mb !!!). And after processing and exiting the macro, the memory was not cleared.

1

u/gk802 24d ago

Good to know I'm not the only one. If you can, go to the feedback hub, category Apps, sub-category Office-Excel and add your experience to my issue report - title is "Excel 365 Version 2408 Memory Leak".