It sounds like whoever set the freeze panes did it with the data filtered (some
rows hidden).

Instead, apply the filter (but have all rows showing), then apply the freeze
panes.



Maver1ck666 wrote:

I have a spreadsheet with a number of autofilters on a title bar which is
then frozen to remain at the top of the screen.

The problem is that when the file is saved which has already been filtered,
when someone else goes in and flushes the filter, the freeze pane moves to
the last record that was previously filtered meaning you cant scroll down the
page. (if that makes sense).

The only way to clear it is to remove the freeze pane and re freeze it again
int eh correct please.

Does anyone have any suggestions please.

Kind regards,
Maver1ck666

--

Dave Peterson