ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   freezed panes and autofilter (https://www.excelbanter.com/excel-discussion-misc-queries/110931-freezed-panes-autofilter.html)

Laurent

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


All times are GMT +1. The time now is 08:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com