Debra Dalgleish explains why and provides some workarounds at:
http://contextures.com/xlautofilter02.html#Count

AKH wrote:

Usually, the number of records that meet the filter criteria on excel show up
in the bottom left hand corner of the spreadsheet but this isn't working.
can anyone shed any light?

--

Dave Peterson