Autofilter Automatically Update

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

brian.baker13

Hi

I have an autofilter that checks on a Planning Board and is set to
filter out non-blanks. When the Planning Board Updates the autofilter
is not updating automatically to show that a new entry has been made
on the Planning Board.

Is there anyway of doing this?

Thanks

Brian
 
You mean that the new entry doesn't appear under the dropdown arrow?

If yes, then there is a limit of 1000 unique entries that will appear under that
dropdown (at least in xl2003 and earlier).

Another problem could be that if you updated the entry by adding a new row, then
that row may not be part of the autofilter range.

If you filter by a different value, do you still see the new entry at the bottom
of the range? Is the row number for that new entry still gray--not blue like
the other filtered data?

If yes, then your autofilter isn't including that row. I'd remove the filter
and reapply it to the whole range.

I select the range myself. I don't let excel guess at the range to be filtered.
 
Back
Top