When I filter data, sometimes I do not get row count retrived

G

gansh_k

When you are using auto filter on a worksheet and then you pick a valu
to filter, you get the list of rows that satisfy that criteria. Also
in the status bar, you get the number of rows retrived as a result o
this filter. Example you will get "3 of 25 rows found" or somethin
like that. Sometimes I do not get that message, I just get a messag
called filter mode. Why does this happen and how can I correct this?

Thank you
 
S

SOS

If your worksheet has any formulae on it they automatically calculat
after filtering thereby suppressing the message "3 of 25 rows".
suggest clicking Tools/Options/Calculation and switching it to manua
for the timebeing and your message will appear.

HTH

Seamu
 
Top