Results 1 to 4 of 4
  1. #1
    Josh
    Guest

    EXCEL Crash on File Open

    I have created an EXCEL '97 workbook that everytime I try to open it, it gives me the following error message:

    "EXCEL caused an invalid page fault in module MSO97.DLL at 0137:3070ab13."

    The file then closes and crashes EXCEL. The file contains a handful of buttons and checkboxes, with all of the VBA code in the model being driven by click events (no OnOpen or AutoExec's). There are passwords on the workbook, worksheets and VBA modules, but not on the open event. So far I have tried:
    - holding the shift key on open,
    - running an EXCELRecovery program (didn't work because pswd protected),
    - running virus checker software (no viruses found)
    - replacing the MSO97.dll
    - disabling macros on open (get message stating that cannot disable MS EXCEL 4.0 macros).
    How can I get into my file or the VBA code?

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EXCEL Crash on File Open

    Sounds like a chore.. Try removing the password. To do so take a look at this thread

    After you've removed the pwd, you can re-run Excel recover and see if that does anything for ya..

    Hope this helps!

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  3. #3
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: EXCEL Crash on File Open

    Hi, This will probably not help- but on one occasion, I was able to fix a file which I could not open in Excel, by opeing it in Internet Explorer, and then resaving it.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  4. #4
    Josh
    Guest

    Re: EXCEL Crash on File Open

    Thanks for the info. I had tried that method but to no avail. I just got the file to open, however, by opening it with Windows NT and then saving down to EXCEL 5.0. I have re-added the protection and the file runs fine.

    Thanks again!

    Josh

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •