error opening excel file
 

hi!
i cannot open this excel file, an microsoft visual basic window appear
saying "An error occur while loading 'Sheet32111111111111111111111111'. Do
you want to continue loading the project?"

i click yes, microsoft window appear and asking if i want to update this
workbook? then i click no a Program Error window appear saying " An error
log is being created"
what happen to the excel file?
the excel file is only 2.6Mb

This looks like a problem that existed in Excel 97.
A worksheet has a VBA name as well as a sheet name.
The VBA name is created automatically when the sheet is created.
In Excel 97 if you copied a with VBA name SheetXXX it would create a
sheet named SheetXXX1 (or SheetXXX2 if SheetXXX1 already existed etc).
Thus a copied sheet's VBA name was always one character longer than the
VBA name of the sheet you copied.

There is a limit of 32 on the length of such sheet names.
It looks like yours has been hit by that limit in some way.

If you could get the workbook to open you could change the sheet name
in properties window in the VB editor. You could try opening it with
the shift key held down.

Alternatively go to a backup version that didn't have the problem and
rename the sheet that you had copied to create the one causing problems
before copying it again.

To avoid the problem in future update to a newer version of Excel, or
always copy a sheet with a shorter VBA name.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup