XL97: Named Locations in Hyperlinks Missing After Saving as HTML

• Microsoft Excel 97 for Windows

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://www.microsoft.com/OfficeFreeStuff/download/Html.exe

   http://www.microsoft.com/

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

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

REFERENCES

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

   html