Re: Serious problem when opening a file

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 spread*** 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$21"}

I don't know what this MiscTables refer to, it is not certainly a *** 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

.