If you remove the data|filter|autofilter, then select the entire range to be
filtered and reapply the data|Filter|autofilter, does it work ok?

I never let excel guess at the range to filter, sort, chart, ...

It doesn't always guess what I want.

Jane wrote:

I have a column with 721 values. I placed Auto-filter in the row just above
the data. There are no blank rows among my rows of data. However, the
drop-down shows NO values.

The workbook is not shared or protected.

what do you recommend?

thanks in advance!! Jane

--

Dave Peterson