Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

Thread: Autofilter arrow wont go away...

  1. #1
    Join Date
    18th August 2004
    Posts
    7

    Autofilter arrow wont go away...

    Has anyone experienced this???

    I have a list of data about 1300 rows and 44 columns. I apply the autofilter to the first row (headers). - no problems. functions correctly.

    The problem is that when I REMOVE the autofilter both manually or programmatically, occassionally some of the cell arrows remain in the cells.

    This is a random occurance and the arrows never go away. I have tried 'clearall', reapplying the autofilter...the 'dead arrow' remains. the cell can be edited, in fact all properties of the cell are configurable but the arrow remains! ?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th August 2004
    Posts
    7
    Did I stump everyone? 24hours and the only post with no response!

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    15th April 2003
    Location
    USA
    Posts
    7,236
    Well, what you describe isn't supposed to happen so that's probably why no one has responded with a fix. Does the problem persist after you closed excel and rebooted your computer? I've noticed many times that Excel (and/or Windows) gets confused and needs to have its memory cleansed before it works properly again.

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    25th January 2003
    Location
    Östersund, Sweden
    Posts
    2,451
    Did I stump everyone? 24hours and the only post with no response!
    Pls see the following post and be also aware of that people answer questions here on a free basis:

    http://ozgrid.com/forum/showthread.php?t=20947
    Kind regards,
    Dennis

    .NET & Excel | 2nd edition PED | MVP

  5. #5
    Join Date
    18th August 2004
    Posts
    7

    Thanks for the tip XL-Dennis

    Incidentally, I am a member of several other forums where I am the one answering questions so I understand the 'free' thing and I certainly understand rule #5. I dont feel the post violated any forum rules, there is no harm in simply following up after 24hrs.

    B

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Sumproduct Wont Add Up
    By mstodge in forum EXCEL HELP
    Replies: 3
    Last Post: May 31st, 2005, 03:33
  2. Numbers that wont SUM!
    By leeryanatkins in forum EXCEL HELP
    Replies: 8
    Last Post: February 3rd, 2005, 19:09
  3. macros wont run
    By Balangan in forum EXCEL HELP
    Replies: 2
    Last Post: May 12th, 2003, 21:56

Bookmarks

Posting Permissions

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