Excel Workbook.htm - Freeze Panes

  • Thread starter Thread starter Bill Neill
  • Start date Start date
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 IE as an .htm file, the Freeze
Panes is not working and the top row just scrolls out of
sight..
Any ideas? tia
 
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, 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.
==============================================
 
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
| >
| >
| >.
| >
 
Back
Top