Microsoft KB Archive/170309

= XL97: Named Locations in Hyperlinks Missing After Saving as HTML =

Article ID: 170309

Article Last Modified on 6/12/2007

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q170309



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



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

http://office.microsoft.com/downloads/9798/html.aspx



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



MORE INFORMATION
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:

http://example.microsoft.com/mydoc.htm#section3

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:

http://example.microsoft.com/mydoc.htm

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.

