I have two Excel spreadsheets. In one the results of applying a filter are
displayed in the status bar - eg. '24 of 144 records found'. In the other I
get just 'Filter mode'.
I've examined the option settings - they appear identical. There are no
macros attached to the sheets either. The '24 of 144 records found' type of
message is very useful. How do I make all my spreadsheets produce it on
filtering?