Microsoft KB Archive/221064

= Nothing happens when clicking a hyperlink in an Excel Web page =

Article ID: 221064

Article Last Modified on 3/27/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q221064



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.



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.



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 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

Additional query words: kbnoOfficeAlertID XL2007 XL2003 XL2002 XL2000

Keywords: kbprb KB221064

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.