Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How Do I open an excel file without Excel Viewer support | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
double click a xls file and start Excel but without the file | Excel Discussion (Misc queries) |