View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Hank[_2_] Hank[_2_] is offline
external usenet poster
 
Posts: 21
Default Freeze Pane Saving

Dave,

Yes, I am saving as xls. All other changes to the workbook saved - except
the freeze pane.

As I asked earlier, could the fact that the row I am trying to freeze also
has auto filter have anything to do with it?
I have found out if I remove auto filter the freeze pane does save.

I really need the auto filter kept. Is there a work around?

Thanks
Hank

"Dave Peterson" wrote in message
...
And you are saving the workbook as a normal workbook (*.xls)--not a text
file
(like .prn or .csv), right?

Hank wrote:

In Excel 2003 I would like to Freeze the header row on each worksheet and
have this "Freeze Pane" save when the workbook is closed.

Should the Freeze pane save? If not, is there a way to do this so the
header rows are always visible. I can indicate which rows I want to
print
at the top of each page with page setup. I'm trying to keep from haveing
to
freeze pane each time I open the workbook.

Thanks
Hank


--

Dave Peterson