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
Highlighted
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
Highlighted
Is this with a specific set of workbooks? If so, can you upload a sanitized copy of one of them?
Related Conversations
How to use the trendline to find percentage change?
fishfish31 in Excel on
0 Replies
tableau
Noemie911 in Excel on
4 Replies
Summarzing data
Ravi_Kumar in Excel on
1 Replies
Referencing the data source for a pivot table
RobMacUK in Excel on
1 Replies
About excel filter function
broog2045 in Excel on
3 Replies