Workbook.htm - Freeze Panes

B

Bill Neill

I am publishing an Excel 2000 Workbook that has 20
worksheet's each with the top row held static with 'Freeze
Panes'.
However, when viewed in IE6 as an .htm file, the Freeze
Panes is not working and the top row just scrolls out of
sight..
Any ideas? tia
 
J

J.E. McGimpsey

While it's not specifically listed, in the Help file for my XL
version ("Limitations of saving data on a Web page"), Freeze Panes
isn't retained when the workbook is saved as HTML.

Worksheets are saved as HTML tables - HTML tables have no capability
to do what Freeze Panes does.

You may be able to use Frames, but it would be a manual modification
of the HTML file, I'd think.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top