excel for mac 2016 hangs when closing file

Excel for mac 2016 hangs when closing file update#
Excel for mac 2016 hangs when closing file windows#

If this button is disabled in the Ribbon then your To enterĭesign Mode select the Design Mode button in the Controls Chunk on theĭeveloper Tab. Turning on Design Mode will allow you to select allĬontrols, not just the basic shapes and form controls. Will only be enabled in Excel if your sheet contains certain types ofĬontrols. Objects on the sheet, the next step is to put your spreadsheet inĭesign Mode if it is supported on your current workbook. Once you have the selection pane open and verified that you have

That 100 objects were pasted into my document. The top of the Selection and Visibility Pane for my sheet. Selection pane is blank then you do not have extra objects on the Selection pane you will see a list of all objects on the current sheetĪnd an indication if the objects are visible or hidden. Selection Pane option making the pane visible). The Editing Chunk > click the Find and Select Dropdown > select the Objects is to turn on the on the Selection Pane (on the Home Tab go to The first thing you want to do is verify that you have additional

I found that the excel document had hundreds of hidden image items that weren't visible.

Excel for mac 2016 hangs when closing file update#

This security bulletin is applicable, look at it and see if you have this update installed or a superseding one that has one of these in it, if not, installing one of these may ameliorate your problem.Īnother solution is to check for hidden picture objects. Hope this helps somebody else out there, as it's not just exclusive to Office 2010. This computer was also being offered an update KB3078667 which has to do with a memory leak that occurs in Desktop Window Manager (dwm.exe).Īfter installing and rebooting, the problem went away.

Excel for mac 2016 hangs when closing file windows#

In this case, Windows updates hadn't been applied for YEARS, and I found out Service Pack 2 for Office 2010 was one of them ( ). I used Process Explorer and took a complete dump of Excel while it was frozen, then installed and ran WinDBG (good beginner guide which is all I used found here), and learned that there was 'heap corruption'. I noticed that the amount of RAM that Excel.exe was using would approximately triple while the program was frozen, and that dwm.exe was using about one core of CPU (12-13% on a quad-core w/ HT versus 1-3%). In my case, Office 2010 version of Excel (32bit) on Windows 7, the program would freeze for MINUTES not seconds. Like you, I read and did all of these things and they didn't help. For those of you who read through all of these answers and did all of these things to no avail, I have another thing for you to try that worked for me.