When using Data, Filter, AutoFilter on some spreadsheets I get a record count
displayed in the bottom left hand corner of the worksheet ...like

" 7 of 1334 records found"

However, on other spreadsheets using the same commands I get

"Filter mode" message instead.

How can I control this to display the " x of y records found" message?