Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Nothing happens when clicking a hyperlink in an Excel Web page


View products that this article applies to.

Symptoms

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

↑ Back to the top


Cause

This problem occurs when the following conditions are true:
  • Only one worksheet in the workbook contains data.
  • The hyperlink points to a blank worksheet.
  • 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.

↑ Back to the top


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.

↑ Back to the top


More information

When you save 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 that 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, as follows in this example:
  • Book1.htm (frameset file)
  • Book1_files (folder)
    • Filelist.xml
    • Sheet001.htm
    • Sheet002.htm
    • Sheet003.htm
    • Stylesheet.css
    • Tabstrip.htm

↑ Back to the top


Keywords: KB221064, kbprb

↑ Back to the top

Article Info
Article ID : 221064
Revision : 4
Created on : 3/27/2007
Published on : 3/27/2007
Exists online : False
Views : 314