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?
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.
 
I suggest you post this question in an Excel newsgroup, perhaps
microsoft.public.excel.crashesgpfs or microsoft.public.excel.
 
If all else fails you have 2 options;

1) Try to get hold of a PC with Excel XP installed, and
use the repair file feature.

2) Submit the file to one of the many websites who will
try and recover the file for you for a small fee (£7-30,
$12-$50)

HTH
 
Thanks for the advice. I'll try posting there.
-----Original Message-----
I suggest you post this question in an Excel newsgroup, perhaps
microsoft.public.excel.crashesgpfs or microsoft.public.excel.
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?
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.
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Back
Top