View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Laurent Laurent is offline
external usenet poster
 
Posts: 16
Default freezed panes and autofilter

Hi,

I am working with a protected shared workbook (only one sheet) where the
first row is locked, in a freezed pane to stay visible, with the Autofilter
turned on. I have freezed the panes with the Autofilter showing all the lines
and before protecting the workbook. I am running Excel 2003.

My problem is that, from time to time, when I open the file, the top pane
includes a few rows and not only the first one. In some case, I even have to
unfreeze the panes because the top pane is bigger than the screen. I move
back the handle to the first row and freeze the panes again to have it right.

This is quite annoying. Why the top pane keeps expanding ? I feel it is
related to the Autofilter but I don't see how...

Thanks for your answer,

Best regards,

Laurent