I have a worksheet with 3000 rows and 20 columns for many users to access,
one at a time (not share file). The first row is the header and I have
applied auto filter so that the user can filter the relevant row for adding
data on the worksheet. I also set freeze pane on cell B2, so that the data
on the first column and first row are always visible when scrolling left or
scrolling down.
The problem I have frequently is that the freeze pane may be moved to other
cell, say B1000, without my notice. When the next user select the auto
filter on the header row, sometime they may not scroll the resulting rows
because the freeze row 1000 is beyond the display screen.
Any idea how the freeze pane position may change to another row? Whenever
this problem occur, I have to unfreeze pane, remove autofilter, goto cell B2,
select freeze pane to reset. But I want to find out the reason so that I
don't have to reset the freeze pane again and again.
Thanks in advance.