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

ID: Q162027

The information in this article applies to:

Microsoft Excel 97 for Windows

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


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

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