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
1
u/gk802 25d ago edited 25d ago
No formulas created by macros. No formatting. Macros to import text files shouldn't be in use in the initial calculation. There are 2 VB functions that determine remaining duration on bonds that act on about 100 cells each. All the rest is standard formulas. In calculation, the spreadsheet consumes memory at about 100MB/second until all memory is consumed. Reverting to 2407, the spreadsheet successfully calculates in about 8 seconds and consumes no more than 300MB of memory at any point in the process.