XL: Nothing Happens When Clicking Hyperlink in Excel Web Page (221064)


The information in this article applies to:

  • Microsoft Excel 2000
  • Microsoft Excel 2002
This article was previously published under Q221064

SYMPTOMS

When your workbook contains a hyperlink to a blank worksheet in the same workbook, if you save the workbook as a Web page and view it in a Web browser, nothing happens when you click the hyperlink.

CAUSE

This problem occurs when the following conditions are true:
  • Only one worksheet in the workbook contains data.

    -and-

  • The hyperlink points to a blank worksheet.

    -and-

  • You save the entire workbook as a Web page.
This behavior occurs because when you save a workbook as a Web page, Excel doesn't save blank worksheets if the workbook contains only one worksheet with data. This allows Excel to write out a single HTML file, thereby conserving disk space.

WORKAROUND

To work around this behavior, enter some text on the worksheet that is the target of the hyperlink. Then, when you save the workbook as a Web page, Excel will create an HTML file to represent the worksheet that is the target of the hyperlink.

MORE INFORMATION

When saving a workbook as HTML, Excel may break the file down into separate component files. If only a single worksheet in the workbook contains data, Excel saves the workbook as a single file (Book1.htm, for example). However, if multiple worksheets in the workbook contain data, Excel uses frames to display the worksheets in a browser. Excel saves the frameset file with the path and file name you specify in the Save As dialog box. It saves the worksheets as separate HTML files in a folder with the same name as the frameset file, for example:

  • Book1.htm (frameset file)
  • Book1_files (folder)
    • Filelist.xml
    • Sheet001.htm
    • Sheet002.htm
    • Sheet003.htm
    • Stylesheet.css
    • Tabstrip.htm
Modification Type:MajorLast Reviewed:10/7/2003
Keywords:kbprb KB221064
©2003 Microsoft Corporation. All rights reserved.