Results 1 to 7 of 7
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Excel2000 crash (Excel2000)

    Hi all

    I have an Excel2000 file with macros.
    I recently added some chart sheets and some array formulas.
    When I open the file in Excel2000 it immediately crashes.
    It won't open with macros disabled (crashes)
    It won't open in Excel 2000 safe mode (crashes).

    It will open in Excel2003 and Excel 2007 no problem.
    I tried saving a new copy version via both Excel2003 and Excel2007.
    But it still crashes immediately I try to open in Excel2000.

    Any suggestions?

    Or do I have to go back to my last working Excel2000 version and start again from there??

    zeddy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Excel2000 crash (Excel2000)

    Try Jan Karel Pieterse's troubleshooting tips for Corrupt Files.
    If that doesn't help, going back to the last working Excel 2000 version might be best.

  3. #3
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel2000 crash (Excel2000)

    Try the suggestion at the bottom of the page HansV has pointed you to: roundtripping through HTML (using Excel 2003).
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Excel2000 crash (Excel2000)

    Thanks HansI tried all the tips.Curiously, as suggested in the tips, if I open the file in Excel XP and save it as a web file, I can then open it succesfully in Excel2000!However, In Excel 2000 I then did a file save as Excel file.It bloats to 3,704Kb (from original size of 955Kb).
    It then crashes when I reopen in Excel 2000

    Guess it's back to the three-week old good version and then re-build from there.

    Kell-der-marge!

    zeddy

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel2000 crash (Excel2000)

    Have you opened the web file in XP and then resaved as excel file? Does that open and save successfully in 2000?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  6. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,823
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Re: Excel2000 crash (Excel2000)

    Hi Jan

    Yes, I also opened the web file OK in XP, resaved as an Excel file in XP, but it crashed immediately when I tried to open it with Excel2000.

    zeddy

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel2000 crash (Excel2000)

    If you like you can send the file to me and I'll have a look. Send me a PM and I'll send you my contact details. Or look for my email link on my website's contact page.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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