I've had a similar problem in Excel 2000 and 2003 with shared files that have
autofiltered sheets. The frozen pane "jumps" down the sheet for some or all
sheets that have an autofilter applied. The seems to occur most often when I
re-open a file, but also can happen when I come back to a file that has been
sitting open and unused on my desktop for a long time. [This happens even if
no one else has accessed the shared file, so may be related to some autosave
function?] Also, the pane "jmping" happens no matter what settings I have
chosen on the Advanced tab of the Shared Worksheet command.

Is there a macro that could "show all" for all filters on all sheets in a
file which could run automarically at the time a file is closed [or saved or
autosaved]? This might solve the problem of the jumping panes.
--
JM


"SCSC" wrote:

I am having the same problem. I have 4 different customized views, and when
I flip from one view to another, my freeze panes screw up. I've tried
setting my freeze pane up while all rows/columns are in view and there are no
filters set, and THEN setting up my customized views, but things are still
wonky. If I ever figure it out, I'll let you know.

B

"Dave Peterson" wrote:

It sounds to me like you applied Window|Freeze panes to that filtered list.

If that's possible, remove the freeze panes, unfilter, apply the freeze panes
just under the header and see if that helps.



stuckfly wrote:

Using Excel 2003. If I freeze panes in a list (so I can see column and/or
row titles), then apply autofilter, then scroll around the panes are
unfrozen. I can go back with the autofilter on and refreeze panes and this
works until I change the autofilter criteria. Those panes are a pain!

--

Dave Peterson