Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Spreadsheet won't open

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Location
    Portland, OR
    Posts
    754
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I receive the following error while trying to open a particular spreadsheet:

    This program has performed an illegal operation and will be shut down.

    ...then Excel closes. I can open other spreadsheets. I don't really care about the data, but I need to recover the code. There is about 2 days worth of VBA coding in it.

    Any ideas?

    Thanks...Mike

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If the code itself is causing the problem, try opening it up with macros disabled to recover you code.
    ?
    Tom

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Portland, OR
    Posts
    754
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the reply.

    No, it crashes Excel on loading, even with macros disabled.

    -Mike

  4. #4
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You can open up the file in wordpad or notepad and pull some code from there, but it is not clean.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Portland, OR
    Posts
    754
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I opened it in Notepad, wordpad, word and even with a disk editor. Not able to extract the code. It look like it tokenizes the keywords. I can see my variable names and comments.

    Thanks...Mike

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi
    Cold boot (that is re boot after coffee or 2 minutes)

    Ermm try this open new doc and save as rubbish1


    now only openexcel and this rubbish1 doc, now file open the doggy file and select NO to macros.. hiCTRl
    F11 and see if lets you in...

    et m know, few other ideas.

    Can you mail me the doc to play with>>>

    If so use JackintheUK@hotmail.com


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi --

    any luck mate??

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  8. #8
    Board Regular
    Join Date
    Apr 2002
    Location
    Portland, OR
    Posts
    754
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I sent the file off to a company that specializes in retreiving corrupt files, to get an estimate on how much they would charge to fix it. They took a while to get back to me so I decided to try upgrading to Excel 2002 becasue one of the improvements was supposed to be the ability to repair corrupt files. I was able to open the file in Excel 2002 so problem solved. Still not sure what happened to it in the first place though. I had been saving the file every 10-15 minutes and giving it new names every few hours. I had not closed Excel for several days. When I did finally close Excel and tried to reopen the latest version it was corrupt. That's when I discovered that all of the previous versions were corrupt as well, back several days. So now I know to close Excel and reopen the file every few hours so I don't risk losing so much work.

    I did finally receive the estimate from the restoration company. They want $169.00 to fix the file.

    Thanks for the suggestions...Mike

  9. #9
    Board Regular
    Join Date
    Apr 2002
    Location
    A Mile High!!
    Posts
    241
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Does it have pivot tables or links in it?

  10. #10
    Board Regular
    Join Date
    Apr 2002
    Location
    Portland, OR
    Posts
    754
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    No. No pivot tables or links.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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