Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

XL2000: Frozen Panes Do Not Stay Frozen on Web Page


View products that this article applies to.

This article was previously published under Q207665

↑ Back to the top


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.

↑ Back to the top


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.

↑ Back to the top


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

↑ Back to the top


More information

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

↑ Back to the top


Keywords: KB207665, kbpending, kbprb, kbweb

↑ Back to the top

Article Info
Article ID : 207665
Revision : 3
Created on : 10/7/2003
Published on : 10/7/2003
Exists online : False
Views : 284