Excel spreadsheet crashes without interaction

Posted on 2011-05-12
Last Modified: 2012-05-11
We currently have a business critical spreadsheet that seems to crash at random. It's an older spreadsheet developed with 2003 but now needs to be used on Excel 2007/2010.

The spreadsheet looks to crash without any user interaction (leaving for 5-10 minutes it will usually crash). It wouldn't appear platform specific as running locally on a Windows 7 desktop with 2007 still crashes, as it also does on the desired Server 2008 TS with Office 2010 platform.

Here's the error from 2010:

Problem signature:
  Problem Event Name:      APPCRASH
  Application Name:      EXCEL.EXE
  Application Version:      14.0.5130.5003
  Application Timestamp:      4d3061cc
  Fault Module Name:      EXCEL.EXE
  Fault Module Version:      14.0.5130.5003
  Fault Module Timestamp:      4d3061cc
  Exception Code:      c0000005
  Exception Offset:      00000000002e9928
  OS Version:      6.1.7600.
  Locale ID:      2057

Additional information about the problem:
  LCID:      1033
  skulcid:      1033

Same error (exception code) also occurs with 2007. I've tried the below with no apparent change:

Changed default printer
Disabled all Addins
Converted to 2010 format
Disabled Macros
Installed all current MS Office Updates via Windows Update

Any help or ideas appreciated, thanks in advance!
Question by:v0r73x
    LVL 33

    Accepted Solution

    The file has any macros running on the background?

    Author Comment

    I'm not aware of any in the background but it does contain Macros.

    I've currently opened Excel in Safe Mode (via holding ctrl) and with the Security Warning to alert that Macros have been disabled it's still crashed on me without doing anything to the spreadsheet itself.
    LVL 85

    Expert Comment

    by:Rory Archibald
    Does it have any external links - querytables, DDE/RTD functions or the like?

    Author Comment

    There's no external links, or special functions from what I can see, I have to apologize as Excel bar the basics isn't my strong suit.

    I've saved the original .xls file to an upgraded .xlsx (being prompted about macro's so tried saving without them) and it doesn't look to have crashed. I'm a little confused as to why it would crash if it is due to macro's when they are definitely disabled though?
    LVL 19

    Assisted Solution

    because of the excel file crashing on multiple computers, it would seem that the problem indeed is inside of the excel file. Does it contain references to add-ins ?
    is it possible to post the macro code ?

    Author Comment

    I went through the Modules/Macro's and they are diabolical. Really messy I'm afraid! Cleared as much as I could and consolidated some of the modules - which fingers crossed appears to have done the trick. I'm not sure where the issue was so unless one of them was perhaps corrupt? Either way the functionality still remains and it hasn't crashed for a couple hours (usually would every 10min or so).

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
    Outlook Free & Paid Tools
    Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now