Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Status Bar with Filter (Excel 2003)

    I created a spreadsheet with a filter. In the status bar it would usually says Ready or Enter in the lower left hand corner. When I select the Autofilter drop down arrow in my "last years" spreadsheey it would say like "3 of 100 records found" in the status bar lower left hand corner (based on my filter request answer. When I do it in my new spreadhsheet this year it only says "Filter Mode". It doesn't give me the record count. Help?

    Thanks in advance.....

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Status Bar with Filter (Excel 2003)

    Hi There this is normally caused by having 51 or more formulas in a list or each formula in the list each has a cell reference, a work around is as follws:

    1. On the Tools menu, click Options.
    2. In the Options dialog box, click the Calculation tab.
    3. On the Calculation tab, click Manual under Calculation.
    4. Filter the list to see the filter results in the status bar.
    Jerry

  3. #3
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Status Bar with Filter (Excel 2003)

    It's because you have more than 51 formulas in your list and Microsoft can't stand to do that many calculations! <img src=/S/drop.gif border=0 alt=drop width=23 height=23> Seriously, it's a know problem Q189479. Microsoft's workaround is to turn off automatic calculations. This is progress? --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •