XL2000: Nothing Happens When Clicking Hyperlink in Excel Web Page

ID: Q221064

The information in this article applies to:

Microsoft Excel 2000

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

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb