Yes, of course, all the rows were visible when I froze the header row. Then I
save the file, close it and email it to the recipient. If the file comes back
unfiltered, all works well.

If the file comes back to me saved in a filtered state, the frozen section
encompasses all the rows down to the first filtered row. This didn't happen
last year in a previous version of Excel. And believe me, the people I am
sending these files to don't have a clue about how to freeze or unfreeze
panes. And it's happening too consistently and often to be a fluke. When I
tried it on my own computer, the same thing happened.

"Dave Peterson" wrote:

Make sure you freeze panes when all the rows are visible.



Auntie wrote:

I have a similar kind of problem.

This is my situation:

Excel 2003 SP2
worksheet with Autofilter set in Row 1
Shared file
Shared file protected
Freeze pane for heading (Row 1)
File saved in a filtered state

The file works fine until I save it in a filtered state. When I reopen the
file, I can unfilter the worksheet, but the freeze pane boundary moves from
just below the heading to just above the first item that was filtered.

I create these files once a year for a large number of people. I didn't have
this problem last year, but I don't remember which version of Excel I was
using to create the files, probably Excel 2000.

I have created and distributed about 50 such files in the last 2 weeks to
distribute to unsophisticated computer users. What a pain to have to now
teach them how to deal with this bug.

Do you have any idea what the problem might be, or how I can prevent it from
happening?

Thanks so much!

--

Dave Peterson