Microsoft KB Archive/207665

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.