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

JP,
A couple of issues.
First is the Sheet name. This is the 'real' name of the worksheet, not the
one you see on the worksheet tab. You have to go into the Visual Basic
Editor to see it in the properties window. That's where you can shorten the
name. Excel has a problem with really long Worksheet names. The way a name
like 'Sheet32111111111111111111111111' happens is if you keep copying a
copied worksheet over and over and over and over..... again. Excel keeps
adding a '1' to the end of the previous name so that 'Sheet321' becomes
'Sheet3211' which becomes 'Sheet321111', etc. until it basically explodes.
Second issue is a kicker. If you can't open that file to change the name
and you REALLY need that information you can copy the information to a new
workbook/worksheet but it's going to look REALLY ugly.
The google search below goes to a thread that can, hopefully, guide you
through.
Good Luck.
Gary Brown

Thread at... (you will probably have to patch this address back together)
http://groups-beta.google.com/group/...c94a8006b1be28





"jp" wrote in message
...
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