XL2000: Frozen Panes Do Not Stay Frozen on Web Page
Article ID: 207665
Article Last Modified on 10/7/2003
APPLIES TO
- Microsoft Excel 2000 Standard Edition
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 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.
Additional query words: XL2000
Keywords: kbweb kbprb kbpending KB207665