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

Last reviewed: February 12, 1998
Article ID: Q162027

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you save a Microsoft Excel 97 workbook as an 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

This behavior is by design in Microsoft Excel 97. However, a new version of the Internet Assistant Wizard creates the Filter tag.

MORE INFORMATION

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

   http://www.microsoft.com/OfficeFreeStuff/excel/

NOTE: Because the Microsoft Web site is constantly updated, the site address may change without notice. If this occurs, link to the Microsoft home page at the following address:

   http://www.microsoft.com/

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 HMTL..." 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:

<TD FORMULA="=Sum(A2:B2)">15.67

Crosstab (PivotTable) Tag Example:

<TABLE border CROSSTAB CROSSTABGRAND=ROWCOLUMN> <TR> <TH ROWFIELD>Store # <TH>Date <TH PAGEFIELD>Channel <TH COLFIELD>Division <TH>Product <TH DATAFIELD AGGREGATOR="SUM">Units <TH>Price <TR><TD>Store 2<TD>1/1/96<TD>Wholesale<TD>Brass<TD>Trumpet<TD>7<TD>325 <TR><TD>Store 6<TD>1/8/96<TD>Wholesale<TD>Electronic<TD>Keyboard<TD>8<TD>795 <TR><TD>Store 5<TD>1/15/96<TD>Wholesale<TD>Brass<TD>Trumpet<TD>4<TD>400 . . . </table>

Filter (Autofilter) Tag Example:

<TABLE> <TR> <TD FILTER=ALL>Store # <TD FILTER=NONBLANKS>Date <TD FILTER=ALL>Channel <TD FILTER=ALL>Division <TR><TD>Store 2<TD>1/8/95<TD>Wholesale<TD>Brass <TR><TD>Store 6<TD>1/8/95<TD>Wholesale<TD>Electronic <TR><TD>Store 5<TD>1/15/95<TD>Wholesale<TD>Brass . . . </TABLE>

Style Tag Example:

<TD STYLE="vnd.ms-excel.numberformat:# ??/??[semicolon]-

 # ??/??[semicolon]#">

REFERENCES

For more information about the new HTML extensions in Microsoft Excel 97 see the Microsoft Excel Web Connectivity Kit. This kit is available on the following Microsoft Web site:

   http://Microsoft.com/Excel/WebQuery

NOTE: Because the Microsoft Web site is constantly updated, the site address may change without notice. If this occurs, link to the Microsoft home page at the following address:

   http://www.microsoft.com/

For more information about Web authoring, click the Index tab in Microsoft Excel 97 Help, type the following text

   html

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

Additional query words: XL97
Keywords : xlloadsave xlweb xlwizard kbualink97
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 12, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.