Sometimes opening and saving in a different version of excel can help (sometimes
not).
If it is a corrupted workbook, you may want to try openoffice. Lots of people
have said that it's recovered workbooks that excel couldn't.
(
http://www.openoffice.org, a 60-65 meg download or a CD)
If the file is really important, there are commercial recovery services. I've
never used it, but you might want to check into:
http://www.officerecovery.com
Antonio wrote:
I have a large .xls file with plenty of VBA, links, data etc.
It opens and works fine on one PC.
However, in the main PC it takes about 8 minutes to open. When it opens it
works fine. But when I open it again it says "unable to open file" and later
on I get "file had too many errors" and that is the end of the file.
I have been working on this problem for days already.
Following the instructions I received here, I deleted all the temp files. It
worked for three days, now I am back with the same problem.
I even removed and reinstalled Office 2003.
Any ideas?
Many thanks,
Antonio
--
Dave Peterson