Excel File not opening after saving in 97/2000

  • Thread starter Thread starter HelpMe
  • Start date Start date
H

HelpMe

This is what happened.
I exported a table from Access 2000 to Excel 2000.
Then I opened the Excel file. Everything was fine. It
opened as 5.0/95 so I saved it as 97/2000.
Went back to Access and exported the same table to the
same Excel file. No message window opened to ask me if I
wanted to replace the existing file with this one. It
just went ahead and exported the data.
Now when I go to open the excel file an error window
comes up telling me that there is an error and that excel
must shutdown. The file does not open.
Why can I not open this file after it was saved in
97/2000 format? Should I have left it in 5.0/95 format?
It seems as though exporting from Access into a 97/2000
Excel format has corrupted the file. When I try to import
this file back into Access a message window
says "External table is not in the expected format".
If anyone can help me on this I would be so ever grateful
because there is a VERY IMPORTANT spreadsheet in this
file. I need to get it open. Thank you in advance.
 
Can't give you a reason why it's happened I'm afraid, but if you have access to
a copy of Excel 2002 or Excel 2003 then they each have an 'open and repair'
option that you could try. Failing that, OpenOffice is very good at opening
corrupt Excel files also, and is available free (60MB+ Download) from
www.openoffice.org

If none of that is an option then by all means send me the file and i will
happily try it in all of those for you to see if I can recover your data - You
would need to take the NOSPAM bit out of my email address.
 
Thanks for the reply. I'll try openoffice as you suggest.
Thanks again for the information.
 
Back
Top