+ Reply to Thread
Results 1 to 16 of 16

Memory problems with Excel 365 and Windows 11

  1. #1
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Memory problems with Excel 365 and Windows 11

    I recently bought a new high end laptop MSI (Intel Core i9-12900H/32GB RAM) and have had many memory problems with windows 11 and excel 365. I am confident these issues are windows 11 related because I have a similar powered desktop with windows 10 and receive none of the same problems.
    I will outline a few of the problems and will attach pictures.
    I have googled the issue and have tried suggested like:
    https://repairit.wondershare.com/exc...gh-memory.html

    Here are the issues:
    1> when a popup opens it comes in transparent, you can't see anything within, I usually have to move it around for the text and buttons to appear.
    2> when I delete rows, usually in mass, they don't disappear until I scroll the screen past the removed data.
    3> I receive high usage warning from microsof.mashup.container.loader.exe
    4> I receive, run out of resource messages when trying to compute large datasets.

    I'm wondering if anyone has had similar problems, and with that, a solution. I have been debating down grading to windows 10.

    Any advice would be great.

    Thank you.
    Attached Images Attached Images

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Memory problems with Excel 365 and Windows 11

    How large is your wkbk? Any volatile functions? Lots of Conditional Formatting?

  3. #3
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Re: Memory problems with Excel 365 and Windows 11

    This file is 22mb, but with little conditional formatting. I have most cells as values to reduce size and increase speed. The transparent popups happen on brand new files however.

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Memory problems with Excel 365 and Windows 11

    Volatile functions? Entire column/rows ranges ? Multi threaded calculations enabled ? ( Options - advanced - formulas)
    Eventually check https://www.techrepublic.com/article...orkbook-bloat/
    Last edited by Pepe Le Mokko; 01-19-2023 at 12:36 PM.

  5. #5
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Re: Memory problems with Excel 365 and Windows 11

    No volatile functions, not using entire rows/columns. I do use multi thread calcs though. On both the laptop with the issue and the desktop without an issue.

    I do not consider this "workbook bloat" rather a software issue between windows 11 and excel 365. I haven't noticed issues with any other programs.

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Memory problems with Excel 365 and Windows 11

    Have you tried reinstalling/repairing O365?

  7. #7
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Re: Memory problems with Excel 365 and Windows 11

    Yes, I tried that. I also did a test of the RAM using mdsched.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Memory problems with Excel 365 and Windows 11

    Quote Originally Posted by Josephrandall View Post
    I do not consider this "workbook bloat" rather a software issue between windows 11 and excel 365. I haven't noticed issues with any other programs.
    Have you tried the suggestions from the article?

  9. #9
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Re: Memory problems with Excel 365 and Windows 11

    the crtl-end trick, yes.

  10. #10
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Memory problems with Excel 365 and Windows 11

    Any chance you could upload the file ( zipped) ?

  11. #11
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,987

    Re: Memory problems with Excel 365 and Windows 11

    Have you tried
    turning off autosave and/or disabling hibernation
    Opening the file in its own instance

  12. #12
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Re: Memory problems with Excel 365 and Windows 11

    Here is a page i copied out from a file that causing me these issues. Its heavily cut down to fit in as a upload for this site.

    @ByteMarks I do not use autosave. I'm not sure what your referring to with hibernation? I open files in their own instance.
    Attached Files Attached Files

  13. #13
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,987

    Re: Memory problems with Excel 365 and Windows 11

    Hibernation/sleep is in the power options.
    https://support.microsoft.com/en-us/...d-8c972e8e6eff
    I only mention it because my place of work experienced some excel memory issues with large files and found that these options were responsible, particularly in laptops and machines with small SSDs.

    You could also try saving it as an xlsb as this usually reduces the size of the file by around a third.

    However, I suspect that you are probably right that it is W11 related as there do seem to be a lot of reports of transparent dialogs after "upgrading" to that OS.

  14. #14
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,065

    Re: Memory problems with Excel 365 and Windows 11

    Same issue with me, using Windows 11 and Excel 2021.

  15. #15
    Forum Contributor
    Join Date
    01-20-2015
    Location
    NB, Canada
    MS-Off Ver
    365
    Posts
    164

    Re: Memory problems with Excel 365 and Windows 11

    update - i reinstalled windows 11 and the issue hasn't appeared, yet.

  16. #16
    Forum Expert
    Join Date
    01-05-2013
    Location
    Singapore
    MS-Off Ver
    H&B2016 & H&B2021
    Posts
    3,065

    Re: Memory problems with Excel 365 and Windows 11

    Thanks Joseph for the update!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Thrashing VBA Memory Leaks. Memory Loop Problems. Uncleared Memory in .Match Range Object
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2017, 05:17 PM
  2. Memory problems with VBA
    By JonasKl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-15-2016, 02:57 PM
  3. Excel 2010 Memory Problems
    By markinpt in forum Excel General
    Replies: 0
    Last Post: 02-15-2013, 01:34 PM
  4. Migration problems from Excel 93 to Windows 7/ Excel 2010
    By AnthonyWB in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 11-29-2010, 12:22 PM
  5. Memory Problems?
    By Caligula in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2008, 03:14 PM
  6. [SOLVED] Memory problems in Excel 2003
    By Richard in forum Excel General
    Replies: 4
    Last Post: 10-19-2005, 09:05 PM
  7. Replies: 0
    Last Post: 10-19-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1