Article ID: 109977
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
This article was previously published under Q109977
SYMPTOMS
If you edit an embedded Microsoft Excel worksheet object in a Microsoft Word for Windows document, and the first sheet in the embedded workbook is hidden, you may receive a general protection (GP) fault when you click the First tab scrolling button on the worksheet.
WORKAROUND
To avoid receiving the GP fault described above when you edit an embedded Microsoft Excel worksheet object, when the first worksheet in the embedded workbook is hidden, do one of the following:
- Unhide the worksheet in Microsoft Excel, move the sheet to another location in the workbook so that it is not the first sheet in the workbook, and then hide the sheet again. -or-
- Avoid using any of the tab scrolling buttons at the bottom of the workbook window. Pressing these buttons when you are editing an embedded worksheet has no effect, because these buttons are disabled in an embedded worksheet. -or-
- Use the Open command rather than the Edit command to edit the worksheet object as follows:
- In Microsoft Word, select the worksheet object you want to edit.
- From the Edit menu, choose Spreadsheet Object and then choose Open.
NOTE: The method above works only if you have not previously edited the embedded worksheet object by double-clicking the object, or by choosing Spreadsheet Object from the Edit menu, and choosing the Edit command.
MORE INFORMATION
When you edit an embedded worksheet object in Microsoft Word by double-clicking the object, or by choosing Spreadsheet Object from the Edit menu, and choosing the Edit command, you cannot hide or unhide a worksheet in the workbook. However, when you open an embedded worksheet object in Microsoft Word by choosing Spreadsheet Object from the Edit menu, and choosing the Open command, you can hide or unhide a worksheet in the workbook.
REFERENCES
For more information about Tab Scrolling Buttons, choose the Search button in Help and type:
scrolling
For more information about Editing A Microsoft Excel Object Embedded In Another Application, choose the Search button in Help and type:
OLE, editing Microsoft Excel objects
Additional query words: 5.00c officeinterop XL
Keywords: KB109977