Freeze Panes not saving

[Dean Suhr]

I am using freeze panes on several sheets. After a save,
close and open the panes are no longer frozen. Why isn't
this attribute sticking (like it used to)? Is it just me?

W'2000 Excel'2002 SP2

 

[Lori Zukerman]

It's not just you Dean! I've been going nuts because it's
happening to me too & I can't figure out why. But mine is
even stranger...I can freeze, save, close then re-open and
the panes are still frozen. However, if I open the file
later in the day or the next day, not frozen.

Anybody have any insight?

Running Excel 2000 SP1

 

[Dean Suhr]

Lori - I haven't very scientific about the dynamics - but
I think you are probably right about an inconsistancy in
whether the freeze panes is sticking. It has been driving
me nuts, too.

FWIW - I am using a mixture of opening workbooks
individually and using a saved workspace to open my
files. Again - I have not taken good notes as to exactly
when this does not work, except to note that it mostly
does not work.

Dean

 

[Guest]

I've had a similar problem in our office today. I think the freeze panes weren't working properly because the Split Panes feature had been activated. When I went to 'Windows' on the menu bar, ticked 'Remove Split', and then froze the panes again it seemed to work

My guess is that the person using the document grazed the box at the top of the vertical scroll bar without even realising it

Does your document have split panes

Mary

 

[Guest]

Dean,
I think you just hit upon what the cause is. I just
started using saved workspaces and have had the problem
ever since. Just went & checked & when I open each file
individually, the panes are frozen. When I open a saved
workspace, they are NOT. Is this a special "feature" that
I'm unaware of?
Well, I guess we now know the root of the problem. I
wonder if there is a fix?

Happy Friday!
Lori

 

[J.E. McGimpsey]

No Fix - frozen panes are not saved in workspaces by design. See

http://support.microsoft.com/default.aspx?scid=kb;en-us;214297