Any chance you have a hidden worksheet named Misctables?
Since you're working with names, get Jan Karel Pieterse's (with Charles
Williams and Matthew Henson) Name Manager:
You can find it at:
NameManager.Zip from
http://www.oaltd.co.uk/mvp
It might make finding/fixing these names easier.
Antonio wrote:
Thank you Alok and Dave for your suggestions.
I have tried all of them except for openoffice and professional services.
In the end what I have done is to create a new spreadsheet where I have
copied one by one every of the dozen sheets.
I got error message like HTML_Control name already exists, several times. I
had to give a new name.
I have never created an HTML_Control name.
The several new HTML_Control1, ..Control2. etc names that I created are in
the Names list, referring to
={"'MiscTables'!$B$2:$E$6","'MiscTables'!$B$7:$E$2 1"}
I don't know what this MiscTables refer to, it is not certainly a sheet that
I have.
I have deleted one of those names but they stay there.
After copying the VBA modules one by one, everything seems to be working
fine but any ideas about this HTML_Control names?
Thanks,
Antonio
"Dave Peterson" wrote:
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
--
Dave Peterson