display count/results of filtering Excel in status bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Found the answer - a bug in Excel which stops the status bar displaying the
count if the sheet contains 51 or more calculated cells. The 'fix' is to turn
off automatic recalculation (Tools > Options - Calculation tab & select
manual calculation)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula results in the status bar 3
Filter status 1
Status bar does not display filter mode 2
Record count in filter mode 1
Results of filters 3
how do i set results to appear in status bar of excel 2
Filter Results in Status Bar 1
Status Bar 1

Back
Top