Filter Count of Records Retrieved.
 

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

Hi amkazen

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"amkazen" wrote in message ...
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

Hi,

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

Andrew