Excel Workbook.htm - Freeze Panes

[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 IE as an .htm file, the Freeze
Panes is not working and the top row just scrolls out of
sight..
Any ideas? tia

 

[Stefan B Rusynko]

HTML does not work like a spreadsheet (and filters)

--




| 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 IE as an .htm file, the Freeze
| Panes is not working and the top row just scrolls out of
| sight..
| Any ideas? tia

 

[Bill Neill]

trust me Stefan - it works like a spreadsheet.. thanks for
your reply but this is a specialist Excel question.. I was
hoping for a specialist reply.

-----Original Message-----
HTML does not work like a spreadsheet (and filters)

--




"Bill Neill" <[email protected]> wrote

in message news:[email protected]...

 

[Thomas A. Rowe]

Bill, the point is that when you convert the Excel file to HTML, you are no
longer using Excel to display the worksheet/book, so features/functions of
the Excel application are not available.

Since this is a "specialist" Excel question, then it should have been post
to the appropriate Excel newsgroup, and not to the FP newsgroup.

If you want to maintain the Excel features/functions, then you will need to
import the Excel document into your web, and then create a hyperlink
directly to it. However you users will have to have Excel installed to view
the file.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[Stefan B Rusynko]

The spreadsheet view controls (freeze panes) is only supported in IE4.01 SP1+ and if you and all users have the Office Web
Components, and when you Save as Web Page and select Interactivity (entire workbook)
See http://office.microsoft.com/assista...ID=HA010548391033&CTT=4&Origin=CH010485201033

For the OWC see
http://office.microsoft.com/assista...yID=ZEU4GwhfG0&Query=OWC&Scope=HP,HA,RC,FX,XT

Or you can just import the .xls file in the web if they have Excel

Without interactivity and the OWC you lose the spreadsheet functionality since Html has no equivalent to freeze panes (unless you do
some custom DHTML coding)
--




| trust me Stefan - it works like a spreadsheet.. thanks for
| your reply but this is a specialist Excel question.. I was
| hoping for a specialist reply.
|
| >-----Original Message-----
| >HTML does not work like a spreadsheet (and filters)
| >
| >--
| >
| >_____________________________________________
| >SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >"Warning - Using the F1 Key will not break anything!" (-;
| >To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| >_____________________________________________
| >
| >
| in message | >| 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 IE as an .htm file, the Freeze
| >| Panes is not working and the top row just scrolls out of
| >| sight..
| >| Any ideas? tia
| >
| >
| >.
| >

 

[Guest]

Many thanks, Stefan, but this is an Office problem.