If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merge data from Excel into different docs in one Word file | sue_w1231 | Mailmerge | 1 | November 16th, 2004 12:55 AM |
Changing Source File of Linked Excel Charts | Brad Bendecl | Powerpoint | 3 | August 4th, 2004 08:44 AM |
Is there an Excel File size limit? | Paul | Worksheet Functions | 2 | July 8th, 2004 08:41 AM |
Excel File will not open if Excel is no open first | Vyyk Drago | General Discussion | 2 | June 23rd, 2004 01:14 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |