Excel 2010 crashing on opening a XLSM

**SonOfOdin** · 06-24-2012, 06:49 AM

Hello all

Hope I can get some help here.

I am working on a file, learning excel / vba. I have a document that I am programming for showing / hiding Form Controls using checkboxes. So far I have a bunch of if-then-else statements in a single module that show/hide checkboxes and dropdowns.

This morning when I came to work on the file, I double clicked it and got an error; "Microsoft Excel has stopped working" which seemed to look for a solution and resulted in a button to close Excel. I tried Open and Repair, and the file did the same thing. However, once this had happened, opening excel from the excel shortcut (rather than from a file) brought up Document Recovery in Excel, and my file was here. I can repair it but I still cant save and then open the repaired file as normal. Once I repair the file, I can see the workbook and I can edit it to my hearts content, but when I save it and close it, then reopen the file I get the same problem. After a repair, my checkboxes are misaligned also.

The repair says: Removed Records: Object from /xl/worksheets/sheet2.xml part The log file doesnt show anything but some basic xml pointing to this statement.

Saving the file without the macro results in the same problem. But a new file will save no problems.

Whats going on? And how can I get past this? Thank you in advance

**SonOfOdin** · 06-24-2012, 07:40 AM

Ok, in the last 5 minutes I have discovered that if I insert a blank page into the front of the workbook, I can save it without the problems mentioned. Not an elegant solution but its saved my hair line.

I'd still appreciate understanding what is going on here. Thanks

**stevie35karlos** · 10-06-2012, 03:03 PM

Try to use recover Excel damaged files by viruses, power failures, system errors, incorrect user actions and etc.

**johnwebsoft** · 04-18-2013, 07:45 AM

Excel file recovery tool to recover and rebuild the corrupt or damaged Excel files format. The software support to recover multiple corrupt xls files and any other files format.
http://www.excelrepairtool.com