![]() |
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