XL2000: Frozen Panes Do Not Stay Frozen on Web Page (207665)
The information in this article applies to:
This article was previously published under Q207665 SYMPTOMS
When you display a Microsoft Excel worksheet in your Web browser, you can scroll rows or columns off of the Web page that were frozen in Excel.
CAUSE
This behavior occurs when you use the Freeze Panes command on your worksheet, and then view the worksheet as a Web page. HTML does not support freezing a part of a table.
WORKAROUND
If you need cells to remain frozen on the screen while you scroll through the worksheet, select the Add interactivity check box when you save your worksheet as a Web page (click Save as Web Page on the File menu).
MORE INFORMATIONFor more information about saving your data on a Web page, click Microsoft Excel Help on the Help menu, type Put a worksheet on a Web page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For more information about what requirements you need to add interactivity to a Web page, click Microsoft Excel Help on the Help menu, type Requirements for putting Microsoft Excel data on a Web page in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
| Modification Type: | Major | Last Reviewed: | 10/7/2003 |
|---|
| Keywords: | kbpending kbprb kbweb KB207665 |
|---|
|