Home

Excel 'crashes' (or 'Keels Over' and Restarts) on Saving or Closing

%3CLINGO-SUB%20id%3D%22lingo-sub-876873%22%20slang%3D%22en-US%22%3EExcel%20'crashes'%20(or%20'Keels%20Over'%20and%20Restarts)%20on%20Saving%20or%20Closing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-876873%22%20slang%3D%22en-US%22%3E%3CP%3EI%20work%20mostly%20with%20xlsm%20Excel%20files%20(i.e.%20ones%20that%20include%20VBA%20macros)%20and%20I%20rarely%20have%20more%20than%202%20or%203%20workbooks%20open%20at%20one%20time.%26nbsp%3B%20Lately%2C%20I%20am%20often%20confronted%20with%20an%20Excel%20message%20%E2%80%9COut%20of%20memory%E2%80%9D%20when%20Saving%20or%20Closing%20even%20quite%20small%20files%20I.e.%20less%20than%20a%201Mb.%26nbsp%3B%20Although%20some%20of%20these%20workbooks%20may%20contain%20say%2025%20public%20variables%2C%20I%20always%20reset%20these%20to%20%E2%80%9C%20%E2%80%9D%20or%20to%20zero%20via%3A%20BeforeSave%2C%20BeforePrint%20and%20BeforeClose%20etc.%2C%20but%20it%20still%20happens%20(BUT%2C%20not%20every%20time%2C%20and%20even%204%20weeks%20with%20MS%20Support%20cannot%20see%20any%20trend%20as%20to%20why!).%26nbsp%3B%20Can%20anyone%20help%20with%20what%20triggers%20this%20Microsoft%20Message%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-876873%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Office%20365%20Macros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-877050%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20'crashes'%20(or%20'Keels%20Over'%20and%20Restarts)%20on%20Saving%20or%20Closing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-877050%22%20slang%3D%22en-US%22%3EIs%20this%20with%20a%20specific%20set%20of%20workbooks%3F%20If%20so%2C%20can%20you%20upload%20a%20sanitized%20copy%20of%20one%20of%20them%3F%3C%2FLINGO-BODY%3E
Roger_AI
Visitor

I work mostly with xlsm Excel files (i.e. ones that include VBA macros) and I rarely have more than 2 or 3 workbooks open at one time.  Lately, I am often confronted with an Excel message “Out of memory” when Saving or Closing even quite small files I.e. less than a 1Mb.  Although some of these workbooks may contain say 25 public variables, I always reset these to “ ” or to zero via: BeforeSave, BeforePrint and BeforeClose etc., but it still happens (BUT, not every time, and even 4 weeks with MS Support cannot see any trend as to why!).  Can anyone help with what triggers this Microsoft Message? 

1 Reply
Is this with a specific set of workbooks? If so, can you upload a sanitized copy of one of them?
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
12 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies