XL2000: Frozen Panes Do Not Stay Frozen on Web Page

• Microsoft Excel 2000

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 : kbdta kbweb
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb