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

  • Thread starter Thread starter gansh_k
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

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

Subtotals and filters 1
New rows not added to data filtering 3
I can't see totals in status bar when I highlight cells 3
count filtered data 1
Data Filter on Selected rows and columns 2
alternate row shading on filtered data 2
Macro - hide rows that are 0 without an auto-filter 3
formula results in the status bar 3

Back
Top