XL97: Hidden or Blank Rows or Columns Are Displayed in HTML File (182473)
The information in this article applies to:
- Microsoft Internet Explorer 4.01 for Windows 95
- Microsoft Internet Explorer 4.0 for Windows 95
- Microsoft Excel 97 for Windows
This article was previously published under Q182473 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:
- Select the range of cells you want to convert to HTML format.
- On the Edit menu, click Go To.
- In the Go To dialog box, click Special.
- Click Visible Cells Only and click OK.
- On the Edit menu, click Copy.
- Select cell A1 in a new worksheet.
- On the Edit menu, click Paste.
- Use this new worksheet with the Internet Assistant Wizard.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for
Windows. This problem no longer occurs in Microsoft Excel 2000.
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.
Modification Type: | Major | Last Reviewed: | 5/13/2003 |
---|
Keywords: | kbbug kbpending kbweb KB182473 |
---|
|