+ Reply to Thread
Results 1 to 5 of 5

Excel 2010 crashing on opening a XLSM

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    29

    Question Excel 2010 crashing on opening a XLSM

    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
    Kind Regards

    - Justin

  2. #2
    Registered User
    Join Date
    06-20-2012
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    29

    Re: Excel 2010 crashing on opening a XLSM

    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

  3. #3
    Registered User
    Join Date
    10-06-2012
    Location
    New York
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Excel 2010 crashing on opening a XLSM

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

  4. #4
    Registered User
    Join Date
    04-18-2013
    Location
    london
    MS-Off Ver
    Excel 2003
    Posts
    1

    Re: Excel 2010 crashing on opening a XLSM

    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

  5. #5
    Registered User
    Join Date
    06-20-2012
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    29

    Re: Excel 2010 crashing on opening a XLSM

    Cheers John. I'll give it a go next time I have a file crack the proverbials..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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