Microsoft KB Archive/162027

= XL97: "Save As HTML" Does Not Create Some Tags =

Article ID: 162027

Article Last Modified on 1/9/2007

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q162027



SYMPTOMS
When you save a Microsoft Excel 97 workbook as a Hypertext Markup Language (HTML) document using the Internet Assistant Wizard, the following tags are not created:

Formula

Crosstab

Filter

NOTE: Microsoft Excel 97 converts an HTML file that contains these tags.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97. However, a new version of the Internet Assistant Wizard creates the Filter tag. This problem no longer occurs in Microsoft Excel 2000.



MORE INFORMATION
You can download the new Html.xla from the following Microsoft Web site:

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

The Web authoring add-in, Internet Assistant Wizard (Html.xla), allows you to save a workbook in the HTML format. This add-in adds the "Save As HTML..." command to the File menu and allows you to convert the information in the active worksheet to an HTML text document.

If the "Save As HTML..." command is not available, load the Internet Assistant Wizard using the Add-in command on the Tools menu. When you run Setup, this add-in is installed as part of the Web Page Authoring (HTML) component.

New HTML Extensions
Microsoft Excel 97 contains many new features for working with Web authoring and supports reading and writing most standard HTML tags. The following four new HTML extensions are included with Microsoft Excel 97:

Formula

Crosstab

Filter

Style

NOTE: Only the Style tag is created when you save a worksheet as an HTML file. The other three tags, Formula, Crosstab, and Filter, are read-only tags; they are not created when you save a worksheet as an HTML text document. Note that a new version of the Internet Assistant Wizard creates the Filter tag. You can download the new Html.xla from the Microsoft Web site.

Formula Tag Example: 15.67 Crosstab (PivotTable) Tag Example: Filter (Autofilter) Tag Example:

