XL2000: Error Message: "An error occurred while loading 'Sheet1111111111111..."
ID: Q236299
|
The information in this article applies to:
SYMPTOMS
In Microsoft Excel 2000, when you try open a file that was saved in Excel 97, you receive an error message similar to the following:
An error occurred while loading 'Sheet111111111111111111111111111'. Do
you want to continue loading the project?
If you click Yes you receive the following error message
This program has performed an illegal operation and will be shut down.
with details similar to the following:
EXCEL caused an invalid page fault in
module VBE6.DLL at 0167:650f6290.
If you click No you receive the error message
File not found.
and Excel does not open the file.
CAUSE
These problems occur when the following conditions are true:
- In Excel 97, you copy a worksheet, adding it back to the same workbook multiple times, either manually or by using a Visual Basic for Applications macro.
-and-
- After many copies, the worksheet (Name) property in Visual Basic for Applications becomes one character longer than the limit of 31 characters.
On the final copy, this may cause the following error message
This program has performed an illegal operation and will be shut down.
with details similar to the following:
Excel has caused an invalid page fault in module EXCEL.EXE at 015f:301dd1a6.
If you have saved the file just prior to this final effort to copy a worksheet, that file may fail to open in Excel 2000.
WORKAROUND
To work around this problem, open the problem file in Excel 97, and copy all but the sheet with the longest (Name) property to a new workbook. You can now open this workbook in Excel 2000.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed
at the beginning of this article.
MORE INFORMATION
Microsoft has changed the way Excel names a copy of a worksheet in Visual Basic for Applications. In Excel 97, when you copy a worksheet, Visual Basic for Applications gives the new worksheet a (Name) property by adding a 1 to the end of the (Name) property of the original sheet. If the (Name) property of the original sheet is "Sheet1", the (Name) property of the copied sheet becomes "Sheet11". This fails after a number of iterations, when the sheet (Name) property becomes longer than 32 characters. At this point, Excel 97 stops responding (crashes).
In Excel 2000, Visual Basic for Applications numerically increments the (Name) property, rather than adding a 1 on the end. Thus, this problem is not likely to occur when you make multiple worksheet copies in Excel 2000.
To view the (Name) property, follow these steps:
- Press ALT+F11 to switch to the Visual Basic Editor.
- On the View menu, click Project Explorer.
- In the Project window, click the plus sign next to the VBAProject name of the workbook to expand the tree.
- Click the plus sign next to the Microsoft Excel Objects folder to see the worksheets.
- Select the last workbook on the tree.
- On the View menu, click Properties Window.
- In the Properties window, click the Alphabetic tab. View the top item which should be (Name).
Normally, you can edit this name in the box to the right.
NOTE: Editing the (Name) property after the problem has occurred does not solve the problem. If you reopen the problem file in Excel 97, switch to the Visual Basic Editor, shorten the text of the worksheet (Name) property that is longer than 31 characters, and try to save the file, Excel crashes and the save fails. Details show:
Excel has caused an invalid page fault in module Ole32.dll at 015f:7ff3da31
This same error message occurs if you delete the last worksheet copied and save the file.
REFERENCES
For more information about how to move or copy sheets, click Microsoft Excel Help on the
Help menu, type Move sheets in the Office Assistant or
the Answer Wizard, and then click Search to view the topic.
Additional query words:
XL2000 dtir VBE6.DLL
Keywords : kbdta xlloadsave DTIR
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug