The information in this article applies to:
SYMPTOMS
When you view a document that is saved in the Hypertext Markup Language
(HTML) format by using the Internet Assistant Wizard outside of Microsoft
Excel, the following problems may occur:
WORKAROUNDTo work around this problem, copy and paste the visible cells to another worksheet. Then, use this data for the Internet Assistant Wizard. To do this, follow these steps:
STATUSMicrosoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem no longer occurs in Microsoft Excel 2000. MORE INFORMATION
Microsoft Excel supports four table tag extensions that allow you to create
HTML tables that appear correctly in a Web browser. When you import these
tables into Microsoft Excel, the tables are enhanced with supporting
features, such as formatting, formulas, PivotTables, and AutoFilter lists.
For example, The HTML table extension <TR STYLE="display:none"> allows data
that is filtered in Microsoft Excel to be displayed properly in HTML
format.
cellspacing=0 cellpadding=0For example, the resulting table tag should be similar to the following: <Table border cellspacing=0 cellpadding=0>For more information about the HTML tag extensions that are written by the Internet Wizard in Microsoft Excel, download the Microsoft Excel Web Connectivity Kit that is located on the following Web page: http://officeupdate.microsoft.com/excel/webquery/samples.htmThe information in this article applies to the updated Internet Assistant Wizard that is included in Microsoft Excel Service Release 1 (SR-1). Please see the following article in the Microsoft Knowledge Base for information about how to obtain and install Microsoft Excel 97 SR-1: Q172475 OFF97: How to Obtain and Install MS Office 97 SR-1 REFERENCESFor more information about the Internet Assistant Wizard in Microsoft Excel 97, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel Help, type the following text Internet Assistant Wizardand then double-click the selected text to go to the "About Microsoft Excel and the Internet" topic. Additional query words: XL97 auto filter autofilter html htm hidden hide rows
Keywords : kbdta kbweb xllist |
Last Reviewed: November 5, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |