I have a shared workbook with autofilter and frozen panes and the "freeze"
moves around when the filter is used by users (it seems to move with the
filters). Although protecting the windows of the workbook solves the
problem, the format of the protected workbook is really not user friendly.
Kind of a small minimized window that you can't maximize and move around.
Because the settings of the users as well as the size of their monitor are
all different, sometimes it's impossible to see the tabs and there is no
horizontal scrolling bar. Basically solving one problem causes another. Is
there a way to solve one without causing the other?
Thanks
Sandra

The only time I've seen this is when the freeze panes was put on after the data
was filtered.

I'd show all the data, then reapply the window|Freeze panes in the correct
location to see if that helps.

Sandra wrote:

I have a shared workbook with autofilter and frozen panes and the "freeze"
moves around when the filter is used by users (it seems to move with the
filters). Although protecting the windows of the workbook solves the
problem, the format of the protected workbook is really not user friendly.
Kind of a small minimized window that you can't maximize and move around.
Because the settings of the users as well as the size of their monitor are
all different, sometimes it's impossible to see the tabs and there is no
horizontal scrolling bar. Basically solving one problem causes another. Is
there a way to solve one without causing the other?
Thanks
Sandra

--

Dave Peterson

I think it might have worked. I should have thought of it. Thank you.
Sandra

"Dave Peterson" wrote:

The only time I've seen this is when the freeze panes was put on after the data
was filtered.

I'd show all the data, then reapply the window|Freeze panes in the correct
location to see if that helps.

Sandra wrote:

I have a shared workbook with autofilter and frozen panes and the "freeze"
moves around when the filter is used by users (it seems to move with the
filters). Although protecting the windows of the workbook solves the
problem, the format of the protected workbook is really not user friendly.
Kind of a small minimized window that you can't maximize and move around.
Because the settings of the users as well as the size of their monitor are
all different, sometimes it's impossible to see the tabs and there is no
horizontal scrolling bar. Basically solving one problem causes another. Is
there a way to solve one without causing the other?
Thanks
Sandra

--

Dave Peterson