L
Laurent
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
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