Forum Discussion

Copper Contributor

Aug 22, 2022

Microsoft Excel 365 HUGE Memory Leak (50 GB RAM)

Hi! I read this article yesterday and I was wondering if you could take a look at a very tiny program I created in Microsoft Excel. I can email you the Excel file if you are interested. T...

Excel

Macros and VBA

NeedMoreRAM

Copper Contributor

ExcelClaro I've been observing the same behavior for a while on files simpler than what you describe. In addition to the sudden memory spike, the video freezes. One of the triggers seems to be switching tabs -- perhaps while a previously invoked operation hasn't finished. However, other triggers exist that I haven't been able to identify. Fortunately, saving is possible, and I'm able to close Excel by clicking the X in the upper right of the window. However, the problem is annoying. A fix would be great.

Here's my setup:

OS: Win 10 21H2 Build 19044.1889

Processor: Intel(R) Core(TM) i9-9980XE CPU @ 3.00GHz 3.00 GHz (18 physical cores)

RAM: 128 GB

Video Card: NVIDIA GeForce RTX 2080 Ti running 3 4k displays via Display Port

Excel 365 Version: 2207 Build 15427.20210

ExcelClaro

Copper Contributor

Aug 31, 2022

NeedMoreRAM Thanks for your reply!

Yes, same symptoms here: video freezes and Windows crashes eventually if the Excel file is NOT closed immediately. I think it has to do with the freeze panes, switching among sheets, *4K display* and MAYBE thousands of records. By curiosity, this error does NOT come out when using one of my lateral monitors which are Full HD, not 4K.

Really annoying! 😬

Here is my setup:

DELL Precison T5820 Workstation
Intel Xeon(R) W-2145 @ 3.7GHz 8 Cores / 16 Threads
64GB RAM DDR4 @ 2666 MHz
Western Digital Black 500GB SN750 NVMe™ SSD 3,100MB/s read 1,600MB/s write
NVIDIA Quadro M2000, 4GB GDDR5, 75W, 106GB/s, PCIe 3.0 x16, 4x DPs
1x BENQ PD3200U 32" 4K Ultra HD LCD Display Port
2x DELL P2719H LED 27'', Full HD, Widescreen, DisplayPort

EDIT: 2022/SEP/14

I have attached some pictures using Sysinternals Process Explorer and DLL Export Viewer. Somehow this library Mso40UIwin32client.dll has something to do with this error. It exposes these 4 functions:

MsoDoFontLinkRgwch 0x000000018026c530 0x0026c530 485 (0x1e5) Mso40UIwin32client.dll C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\Mso40UIwin32client.dll Exported Function

MsoPwlfFromFlinfo 0x000000018030b1b0 0x0030b1b0 1150 (0x47e) Mso40UIwin32client.dll C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\Mso40UIwin32client.dll Exported Function

MsoCrCbvGet 0x00000001801ee190 0x001ee190 1933 (0x78d) Mso40UIwin32client.dll C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\Mso40UIwin32client.dll Exported Function

MsoFreeFlinfo 0x000000018030b970 0x0030b970 2751 (0xabf) Mso40UIwin32client.dll C:\Program Files\Microsoft Office\root\vfs\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\Mso40UIwin32client.dll Exported Function

NeedMoreRAM
Copper Contributor
Sep 01, 2022
ExcelClaro I'll start documenting specifics here whenever I observe this phenomenon. One other note for now is that I've had instances where RAM usage has spiked to 80GB-90GB before returning back to the normal range for the file I'm using (generally 200MB-500MB). In those cases, video begins updating normally, and I can work with the file again -- even though subsequent memory spikes seem to happen more frequently. In other instances, the RAM usage goes past 90GB, but I've always closed Excel before reaching my system limit.
- tomoam2
  Copper Contributor
  Sep 14, 2022
  NeedMoreRAM
  Same here...
  My PC: AMD 5900X + 64GB + RTX3080Ti + 3440x1440x60Hz + Windows 10 Pro + Excel 365
  If Excel works normally, it consumes 150-500MB of RAM. When it starts to lag, it consumes 40+GB. Usually the image freezes for a while and the only solution is to save the sheet and reopen Excel.
  
  For me, the problem has been present at least from June 2022... I tried to solve the problem with a clean installation of Windows 10, then Windows 11 (no comment), drivers update or outdate... then I screamed at my PC and threatened him with a hammer... 😉
  
  I noticed that there is no problem if:
  - using Excel 2010
  - using Excel 365 with "Hardware Acceleration" disabled
  (this option has been removed some time ago - big "thanks" to Microsoft)
  - ExcelClaro
    Copper Contributor
    Sep 15, 2022
    Thanks for your reply! It was fun to read. 😁 I can feel your frustration. 😕
    
    Yes, the very same symptoms are there: specially the 4K monitor. I think that's the main variable suspect.
    
    Hope Microsoft gets it fixed ASAP. 🙏🏻