Excel 2007 Panes keep unfreezing themselves

T

Ted M H

I've painstakingly frozen rows and columns in about 25 worksheets in a single
file only to discover a bit later that they've all become unfrozen. My sense
is that I'm probably doing something to cause this. Or is there some known
thing that causes frozen panes to unfreeze themselves?

A couple of possibly relevant facts:

-I'm keeping several workbooks open at the same time and I'm moving back and
forth between them, but I'm only freezing panes in one of them.
-I'm running several macros to put formulas in the worksheets, but there's
nothing that I can see in the macros that would affect the freezing.
-Worksheets are not protected

Any ideas?
 

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