Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Getting Error while opening Microsoft Excel 2000 file in Excel 2003

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 17-02-2012
Member
 
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.

Reply With Quote
  #2  
Old 17-02-2012
Member
 
Join Date: May 2011
Posts: 445
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.
Reply With Quote
  #3  
Old 17-02-2012
Member
 
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.
Reply With Quote
  #4  
Old 17-02-2012
Member
 
Join Date: Aug 2011
Posts: 687
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."
Reply With Quote
  #5  
Old 17-02-2012
Member
 
Join Date: Jul 2011
Posts: 428
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.
Reply With Quote
  #6  
Old 17-02-2012
Member
 
Join Date: Aug 2011
Posts: 453
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.
Reply With Quote
  #7  
Old 17-02-2012
Member
 
Join Date: Aug 2011
Posts: 575
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Getting Error while opening Microsoft Excel 2000 file in Excel 2003"
Thread Thread Starter Forum Replies Last Post
Getting error when opening excel file using a VB script Madri Software Development 4 18-07-2012 06:27 PM
Cell format errors appears in Excel 2003 but not in Excel 2000 @nki$achi MS Office Support 1 24-01-2012 04:00 PM
How to see full file path in Microsoft Excel 2003 Eas!war MS Office Support 2 21-01-2012 01:15 PM
Opening WK1 File in Microsoft Excel 2007 $horizon$ Windows Software 3 11-01-2012 05:07 PM
Configuring Internet Explorer 8 to open Excel file in to Microsoft Excel Aaghaz Technology & Internet 4 13-02-2011 09:37 AM


All times are GMT +5.5. The time now is 11:28 AM.