Freeze panes problems in shared workbook

S

Sandra

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top