Excel 2002 Worksheets You View in a Frame Disappear (810813)


The information in this article applies to:

  • Microsoft Internet Explorer version 6 for Windows XP
  • Microsoft Internet Explorer version 6 for Windows 2000
  • Microsoft Internet Explorer version 6 for Windows 98
  • Microsoft Internet Explorer version 6 for Windows Millennium Edition
  • Microsoft Internet Explorer version 6 for Windows NT 4.0
  • Microsoft Internet Explorer version 6 for Windows XP 64-Bit Edition
  • Microsoft Excel 2002

SYMPTOMS

After you complete the following steps, Microsoft Excel worksheets in a workbook may disappear when you click them, and you may be unable to select individual cells in the workbook:
  1. You are working with frames in an HTML document.
  2. You create hyperlinks to Excel workbooks from a sidebar page that target the main frame pane.
  3. When you click the first hyperlink to populate the main pane with one Excel workbook, the Excel workbook appears as you expect.
  4. You click the other hyperlink after you use the first hyperlink. You do so to populate the main pane with another workbook.

CAUSE

This issue may occur if the Excel object is not properly substantiated when you activate the second hyperlink.

WORKAROUND

To work around this issue, use either of the following methods:
  • Refresh the whole frameset to properly substantiate the Excel workbook.
  • Save the Excel workbooks as an HTML file:
    1. In Excel, open the first workbook.
    2. On the File menu, click Save As.
    3. In the Save as type box, click Web page(*.htm, *.html).
    4. Click Save: Entire Workbook, and then click Add interactivity if you want viewers of the workbook to interact with the contents of the workbook.
    5. If you want to use this feature, click Autorepublish every time this workbook is saved, click the folder in which you want to save the file, and then click Publish. You can now link to an HTML version of your workbook from any page in your frameset.
Modification Type:MinorLast Reviewed:1/7/2006
Keywords:kbui kbprb KB810813
©2004 Microsoft Corporation. All rights reserved.