Excel 2000

K

Kathy Smith

when i run a filter the number of records being filtered
does not display on the status bar.
 
G

Gareth

have you of formulae which 'look' at the data being filtered?

I found that if you have SUMPRODUCT or other similar functions calculating
the data being filtered than the status bar does not work.

If you set Calculation to Manual it will work, but remember to switch back
to Automatic afterwards.

Gareth
 

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

Top