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

ID: Q162027

The information in this article applies to:

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.

MORE INFORMATION

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

   http://officeupdate.microsoft.com/downloadDetails/html.htm
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://officeupdate.microsoft.com/excel/webquery/samples.htm
For more information about Web authoring, click Contents And Index on the Help menu, 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          : kbualink97 kbdta kbweb xlloadsave xlwiz 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: November 1, 1998