Results 1 to 7 of 7

Thread: Getting Error while opening Microsoft Excel 2000 file in Excel 2003

  1. #1
    Join Date
    Nov 2011
    Posts
    126

    Getting Error while opening Microsoft Excel 2000 file in Excel 2003

    I am going crazy with this one. When I open an Excel 2000 file in my Windows XP (sp2) Excel 2003 I get the following. "Microsoft Office Excel has encountered a problem and needs to close. We are sorry for the inconvenience" which then generally butchers the file (sometimes does almost ok in trying to "repair" it). I have tried this on two separate computers with Excel 2003 - same results. NOTE: Excel 2000 opens it perfectly on third pc.

  2. #2
    Join Date
    May 2011
    Posts
    449

    Re: Getting Error while opening Microsoft Excel 2000 file in Excel 2003

    Does this happen with all files or only a single one. If the latter: sounds like a corrupted file for me. You can try repairing the document when you are opening it. Click on Open from File Menu and below save button you can see a small arrow. Just click on it and click Repair.

  3. #3
    Join Date
    May 2011
    Posts
    410

    Re: Getting Error while opening Microsoft Excel 2000 file in Excel 2003

    Sounds like a corrupted file. Try opening it in Excel 2002, saving as XML (with a different name) and reopening it, then copy across the charts, VBProject etc that saving as XML strips out.

  4. #4
    Join Date
    Aug 2011
    Posts
    700

    Re: Getting Error while opening Microsoft Excel 2000 file in Excel 2003

    This file has seen many "versions" as its improved. the "old" ones can be opened in 2000 and 2003 only lately the newer versions can still only be opened in 2000, not 2003. If it can still be opened in excel 2000 - how do we "find" this corruption. Excel itself didn't really give a good clues. "Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted."

  5. #5
    Join Date
    Jul 2011
    Posts
    435

    Re: Getting Error while opening Microsoft Excel 2000 file in Excel 2003

    I don't own xl2003, but if you do File> save as, do you see an option for "XML Spreadsheet *.XML" in the save as type box at the bottom of the dialog. If that didn't help, maybe opening the workbook in OpenOffice and saving there would clean it up enough for excel to accept it.

  6. #6
    Join Date
    Aug 2011
    Posts
    461

    Re: Getting Error while opening Microsoft Excel 2000 file in Excel 2003

    If I may add some information to track this problem. The Excel file does not use VBA (No Macros at all !). I know for a fact that others can open it - not sure of their Excel version though. I'll try to find out. Is there a "compatibility" mode for Excel 2003 that can open "older" excel files.

  7. #7
    Join Date
    Aug 2011
    Posts
    582

    Re: Getting Error while opening Microsoft Excel 2000 file in Excel 2003

    Quick update. on second pc - completely wiped away all MS office, rebooted, full reinstall of 2003 office - (it asked for license key again) - reboot - BEFORE even appealing office service patch - i tried and failed to open that file. It is using a formula name not recognized for some reason. I have XL2003 and get the same errors. I can get it open but many of the formula have #NAME! errors. Sounds like a dodgy file to me.

Similar Threads

  1. Getting error when opening excel file using a VB script
    By Madri in forum Software Development
    Replies: 4
    Last Post: 18-07-2012, 06:27 PM
  2. Cell format errors appears in Excel 2003 but not in Excel 2000
    By @nki$achi in forum MS Office Support
    Replies: 1
    Last Post: 24-01-2012, 04:00 PM
  3. How to see full file path in Microsoft Excel 2003
    By Eas!war in forum MS Office Support
    Replies: 2
    Last Post: 21-01-2012, 01:15 PM
  4. Opening WK1 File in Microsoft Excel 2007
    By $horizon$ in forum Windows Software
    Replies: 3
    Last Post: 11-01-2012, 05:07 PM
  5. Replies: 4
    Last Post: 13-02-2011, 09:37 AM

Posting Permissions

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