Release memory after large workbook is closed
Excel does not appear to release all memory previously used when large workbooks were open, thus limiting the number/size of workbooks that can be subsequently opened in that instance of Excel. If a passenger gets off the bus, the seat immediately becomes free for someone else - do the same in Excel!
Has this issue resolved?
We are migrating from Office 2010 to Office 2016, there are incidents of memory not release even after excel file is closed. Wonder any solution for it.
Thanks in advance
Col Delane commented
I understand that Excel 2016 (and perhaps XL 2013) has [partially?] overcome this problem by opening every workbook as a separate instance of Excel whilst still allowing each instance to interact with the others just like having multiple workbooks open in a single instance as in 2010. (Having said that, I do NOT know whether the memory allocated to each instance has been increased in 2016.)
Angel Trujillo commented
I'm having the same issue. I have a macro that opens and closes (at least tries to) more than 100 files. I looked at the Task Manager and observed how the memory used by Excel just keep growing and growing, even after each file is closed.
I cannot believe there's no way around this still.
I've only had Office 365 for two days now and this has quickly become a hindrance for not only myself but everybody in my office. Excel is opening new workbooks but they really aren't in separate instances. This is why you can copy tabs freely between workbooks and why when you calculate a data intensive formula in one workbook, all workbooks are frozen calculating the same thing, essentially blocking you from working in other workbooks until the function is completed. I have this problem daily and the end result is always Excel first not saving my workbooks, then workbooks turning to solid gray screens, then windows errors telling me there is not enough memory to complete the function - even if it's just trying to close a tab or close the workbook. I have to force close through task manager and reboot my computer. Even after all Excel workbooks are closed, task manager still shows one instance of Excel using over 1GB of RAM. I have a brand new machine with plenty of processing power and 8GB of RAM. This is a known issue and to be blunt, is completely unacceptable from an end-user perspective. Microsoft has cornered and monopolized the office software market and for the amount of money paid out for licensing to Microsoft this should be at the top of the list of bug fixes.
It takes me less time to reboot my machine than it does to escape the domino effect of errors resulting from this bug to even be able to restart. I give this 3 of my remaining 4 votes.