Filter Count of Records Retrieved.

[Guest]

Hi, My question relates to using filters. Why doesn't a count show in the
lower left corner of the window everytime I use a filter. Sometimes there is
a response that says "51 records out of 2,000 records retrieved" or something
similar. However, sometimes the records are retrieved but no count is
displayed. Thi sis a little thing but I am curious. Can any of you provide
an answer? I haved saved the spreadsheet and then used the filter, I have
closed and reopened the spreadsheet, I have cleared any previous filter and
then refiltered, etc. etc. but nothing changes. Sometimes a count is there,
other times no count. Thanks.

Andrew

 

[Ron de Bruin]

Hi amkazen

See
http://www.contextures.com/xlautofilter02.html#Count

 

[Guest]

Hi,

Thanks for the reply. I went to Tools, Options, and changed from automatic
to manual calculation, solving the problem.

Andrew