I don't have a guess why the suggestions didn't work--or what caused the
problem.

But glad you found a solution.

Kathy wrote:

"Dave Peterson" wrote:

How are you applying that autofilter. Are you selecting the column or are you
selecting only the cells/rows you want filtered. My suggestion was to select
the complete range first: A1:X19 (or whatever the bottom right corner is).
Then apply data|filter|autofilter.

I was selecting the range of cells, just as you suggested. That is, I had
tried that as well as selecting the rows and not making a selection. None of
those solved the problem.

I can't follow the reset procedure because the "last cell" seems to be below
row 1000, and we have some reference data in Z1001 ff.

However, I did a workaround by copying the data in the "template" workbook
into a new workbook. That seems to have solved the problem. I'm still
curious, though, what caused it in the first place....

--

Dave Peterson