Microsoft KB Archive/170309

From BetaArchive Wiki
Knowledge Base

Article ID: 170309

Article Last Modified on 6/12/2007


  • Microsoft Excel 97 Standard Edition

This article was previously published under Q170309


In Microsoft Excel 97, when you save a worksheet as a Hypertext Markup Language (HTML) document by using the Internet Assistant Wizard add-in, named locations in hyperlinks are not preserved.


The Internet Assistant Wizard, Html.xla, which is included with Microsoft Excel 97 and allows you to save HTML files, does not support saving named locations in hyperlinks. This is also true of the updated Microsoft Internet Assistant Wizard add-in that is available from the following Microsoft Web site:


This behavior is by design of Microsoft Excel 97. This feature is under review and will be considered for inclusion in a future release.


In Microsoft Excel 97, you can create a hyperlink to an external Web location on a worksheet by clicking Hyperlink on the Insert menu. As part of the hyperlink, you can specify a named location in the target document. An example of this kind of hyperlink is as follows:

Note that "section3" is the named location in Mydoc.htm.

Clicking the hyperlink opens the target HTML file, Mydoc.htm, in Microsoft Internet Explorer and positions the section3 location at the top of the browser window.

If you save a Microsoft Excel worksheet as an HTML document, the hyperlink to the target document is preserved; however, the reference to the named location in the target document is not included in the HTML file. For example, the resulting link in the HTML file is as follows:

Note that the link does not contain the reference to section3. Clicking on the hyperlink opens the target document but ignores the named location you previously specified.


For more information about converting Microsoft Excel files to HTML format, click the Index tab in Microsoft Excel Help, type the following text


and then double-click the selected text to go to the "Publish Microsoft Excel data on the Web" topic.

Additional query words: 9 bookmark

Keywords: kbdownload kbprb kbweb KB170309