Excel 2013 Crashes While Open Excel File With Macro

I have tried the two most recommended solutions I searched online to solve my problem in excel but all of them do not help. Excel 2013 still stopped working whenever I open a macro-enabled excel file which is created in an older version of excel. The two solutions include:

1. Disable add-in

2. Open excel file in safe mode

I herewith attached the event log for reference. (Wondering is it the correct one I copied?)

Log Name:      Application

Source:        Application Error
Date:          23/9/2013 12:42:14 PM
Event ID:      1000
Task Category: (100)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      JinJie-PC
Description:
Faulting application name: EXCEL.EXE, version: 15.0.4535.1003, time stamp: 0x520096e2
Faulting module name: EXCEL.EXE, version: 15.0.4535.1003, time stamp: 0x520096e2
Exception code: 0xc0000005
Fault offset: 0x0001edef
Faulting process id: 0x10cc
Faulting application start time: 0x01ceb817452d3c27
Faulting application path: C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE
Faulting module path: C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE
Report Id: 843fd48e-240a-11e3-8eed-f01faf2f4be6
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="Application Error" />
    <EventID Qualifiers="0">1000</EventID>
    <Level>2</Level>
    <Task>100</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-09-23T04:42:14.000000000Z" />
    <EventRecordID>15442</EventRecordID>
    <Channel>Application</Channel>
    <Computer>JinJie-PC</Computer>
    <Security />
  </System>
  <EventData>
    <Data>EXCEL.EXE</Data>
    <Data>15.0.4535.1003</Data>
    <Data>520096e2</Data>
    <Data>EXCEL.EXE</Data>
    <Data>15.0.4535.1003</Data>
    <Data>520096e2</Data>
    <Data>c0000005</Data>
    <Data>0001edef</Data>
    <Data>10cc</Data>
    <Data>01ceb817452d3c27</Data>
    <Data>C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE</Data>
    <Data>C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE</Data>
    <Data>843fd48e-240a-11e3-8eed-f01faf2f4be6</Data>
  </EventData>
</Event>

September 23rd, 2013 2:13am

Hi

Did Excel crash when you open the file in safe mode?

If it still crashed, copy the content of your excel file to a new workbook to check the issue.

When it worked fine in safe mode, do a repair for Office in Control panel>Program and features>Office 2013>Change>Repair.

Also some of our customers solved the issue with deleting some format through change extension name to zip, and then the file can be open , and Excel not stop working.

In addition, here is the blog on how to fix 0xC0000005 error for your reference:

http://compfreakstars.blogspot.co.uk/2011/11/0xc0000005-error-every-day-many.html

(Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

Sincerely

Tylor Wang
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
September 24th, 2013 4:35am

Hi

Did Excel crash when you open the file in safe mode?

If it still crashed, copy the content of your excel file to a new workbook to check the issue.

When it worked fine in safe mode, do a repair for Office in Control panel>Program and features>Office 2013>Change>Repair.

Also some of our customers solved the issue with deleting some format through change extension name to zip, and then the file can be open , and Excel not stop working.

In addition, here is the blog on how to fix 0xC0000005 error for your reference:

http://compfreakstars.blogspot.co.uk/2011/11/0xc0000005-error-every-day-many.html

(Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

Sincerely

Tylor Wang
TechNet Community Support

September 24th, 2013 8:32am

Hi

Did Excel crash when you open the file in safe mode?

If it still crashed, copy the content of your excel file to a new workbook to check the issue.

When it worked fine in safe mode, do a repair for Office in Control panel>Program and features>Office 2013>Change>Repair.

Also some of our customers solved the issue with deleting some format through change extension name to zip, and then the file can be open , and Excel not stop working.

In addition, here is the blog on how to fix 0xC0000005 error for your reference:

http://compfreakstars.blogspot.co.uk/2011/11/0xc0000005-error-every-day-many.html

(Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.)

Sincerely

Tylor Wang
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
September 24th, 2013 8:32am

Hi Tylor

I had very similar problem:

Everytime i do ctrl + a - or ctrl+V or touch the macro buttons - it crashes right away.

In safe mode it is fine.

I already tried to repair it, block all add ins, and even re install.

What should i do?

March 29th, 2015 2:55am

I have had this issue come up a lot, after I switched to the newest 64-bit Excel version. What is very strange is that I have files that worked for a long time, but randomly without changing anything in the macros, at some point after weeks they crash and I cannot open them anymore. Repairing etc. does not work, as it messes up all the formatting etc.

Luckily I found one fix that has always worked for me:

  1. Disable Macros
  2. Rename the file extension to .xls
  3. Open the file
  4. Excel will tell you that the extension does not match. Click open anyway.
  5. Open the VBA Editor and cut and paste all VBA Code out of the sheets, modules etc. to some place, e.g. a word file.
  6. Make sure really all VBA code is deleted and save as .xlsx
  7. Add all your VBA code back into the file and save as .xlsb or .xlsm or whatever you used to have for your file.
  8. Your file should work properly without crashing again.

This has saved me a lot of headaches, but if anybody knows why perfectly fine working macro files, suddenly start crashing without altering the code in any way, please let me know.



  • Edited by Mustikah 22 hours 28 minutes ago
Free Windows Admin Tool Kit Click here and download it now
May 12th, 2015 5:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics