XL: Hidden or Blank Rows or Columns Are Displayed in HTML File

Last reviewed: March 16, 1998
Article ID: Q182473
The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Internet Explorer versions 4.0, 4.01 for Windows 95

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:

  • Rows or columns that are hidden manually or with AutoFilter are displayed.

        -or-
    
  • Blank spaces appear in place of hidden rows or columns.

NOTE: The results vary depending on the Web browser you use and the way the data is organized in the worksheet.

WORKAROUND

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

  1. Select the range of cells you want to convert to HTML format.

  2. On the Edit menu, click Go To.

  3. In the Go To dialog box, click Special.

  4. Select Visible Cells Only and click OK.

  5. On the Edit menu, click Copy.

  6. Select cell A1 in a new worksheet.

  7. On the Edit menu, click Paste.

  8. Use this new worksheet with the Internet Assistant Wizard.

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.

NOTE: Microsoft Internet Explorer 3.x does not support this HTML extension and displays the hidden data.

Microsoft Internet Explorer 4.0 supports this HTML extension, so it displays filtered data properly. However, Microsoft Internet Explorer 4.0 may display gaps between visible data. It may be possible to reduce the size of the gaps by editing the HTML file. Use a text editor, such as SimpleText, and add the following cell spacing and padding information to the table border tag:

   cellspacing=0 cellpadding=0

For 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://www.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 and search for the file:

   http://www.microsoft.com/

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

   ARTICLE-ID: Q172475
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-1

REFERENCES

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

and 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 : xllist xlweb kbdta
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbbug
Solution Type : kbpending


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: March 16, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.