Excel 365 Memory Issue

[u/gk802]

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

[u/AxelMoor]

Are there any links? Mainly external (internet), linked images, calls in the workbook, or PowerBI for external data (network, internet, etc).

Version 2408 (Build 17928.20114) changed a lot in this regard. To increase the performance of business networks, 365 now accumulates a lot of data on the local computer to avoid network traffic as if it were a kind of cache - and it is (very) large indeed.

Look in the workbook for any links or objects that currently, or in the past, gathered external data, and supposedly should be disabled.

Check if the workbook data is all of local origin, or if it was downloaded from the internet at some point.

If the workbook does not have any form of external communication, create a new workbook without any content and check the behavior of Excel in Memory and Network in the Task Manager - check the Excel settings for any network activity, unauthorized downloads, obtaining external data, sharing, services such as Azure or associated with Purview, etc.

Check the Account in Excel >> Files the status of your subscription.

It is hard to analyze without physically seeing what is happening.

[u/Andrassz → u/AxelMoor]

Hi! Can you help where I find the detailed update description for excle 2408v? I find something on the internet but It is nothing just marketing bullshit. Thanks for your help.

[u/AxelMoor → u/Andrassz]

I don't know if this helps, Microsoft only publishes the "Release Notes" - which forces us to read all the changes from previous versions to get an idea of ​​the details of the current version.

Here is a list of more "serious" sources to consult:
1. Release notes for Current Channel
https://learn.microsoft.com/en-us/officeupdates/current-channel#version-2408-august-26

1. Excel performance: Performance and limit improvements
   https://learn.microsoft.com/en-us/office/vba/excel/concepts/excel-performance/excel-performance-and-limit-improvements

2. Office 365: A guide to the updates
   https://www.computerworld.com/article/1710697/office-365-a-guide-to-the-updates.html

3. Office 2021 and Office LTSC for Windows and Mac FAQ
   https://support.microsoft.com/en-us/office/office-2021-and-office-ltsc-for-windows-and-mac-faq-d574cf0b-3ebc-42cf-9035-a3b837e0463c

Follow some source links from the articles above and you may be able to find even more details.

Regarding the 'data accumulation that 365 does on computers to avoid network traffic and improve bandwidth usage' - I read an article a few days ago - but since I cleared the browser history I still couldn't find the article. I'm sorry about that, if and when found it, I'll post it here.

Regarding the topic proposed by the OP - now, I agree that the cause is in the VBA macro - objects that are not set to "nothing" after use, for example, to free up memory - and that in this version, for some reason, memory management only made it worse.

[u/Andrassz → u/AxelMoor]

Thank you for your response and for taking the time. Regarding the sentence you quoted, I am also looking for a solution or some information about what has changed between the 2407v and 2408v. If you find the article and attach it here, I would be very grateful.