+ Reply to Thread
Results 1 to 6 of 6

No filter buttons

  1. #1
    Reney Langlois
    Guest

    No filter buttons

    Hi,
    I'm using Excel 2000. Recent problem. When I try to
    apply a filter to any table of data, the table header
    doesn't show the arrow buttons as part of each header
    cell. There is no error message and when I go back to the
    Data-Filter menu, the option is selected as normal.
    Probably something simple but I can't find it. I've
    rebooted and made simple tables to troubleshoot the
    problem, but so far nothing.

    Thanks much.

    Reney



  2. #2
    Dave Peterson
    Guest

    Re: No filter buttons

    Sometimes those pesky arrows will reappear if you minimize excel's window, then
    resize it.

    Sometimes if you minimize the worksheet's window and resize it.

    Sometimes closing and reopening.

    Sometimes removing the filter and reapplying.

    I've even deleted that header row and added it back (I _think_ that sometimes
    worked.)

    Not much help, huh?


    Reney Langlois wrote:
    >
    > Hi,
    > I'm using Excel 2000. Recent problem. When I try to
    > apply a filter to any table of data, the table header
    > doesn't show the arrow buttons as part of each header
    > cell. There is no error message and when I go back to the
    > Data-Filter menu, the option is selected as normal.
    > Probably something simple but I can't find it. I've
    > rebooted and made simple tables to troubleshoot the
    > problem, but so far nothing.
    >
    > Thanks much.
    >
    > Reney


    --

    Dave Peterson

  3. #3
    Gord Dibben
    Guest

    Re: No filter buttons

    Reney

    Possible you have Tools>Options>View>Objects "Hide All" checked.


    Gord Dibben Excel MVP

    On Wed, 9 Feb 2005 14:44:08 -0800, "Reney Langlois"
    <anonymous@discussions.microsoft.com> wrote:

    >Hi,
    > I'm using Excel 2000. Recent problem. When I try to
    >apply a filter to any table of data, the table header
    >doesn't show the arrow buttons as part of each header
    >cell. There is no error message and when I go back to the
    >Data-Filter menu, the option is selected as normal.
    >Probably something simple but I can't find it. I've
    >rebooted and made simple tables to troubleshoot the
    >problem, but so far nothing.
    >
    >Thanks much.
    >
    >Reney
    >



  4. #4
    Francis Hayes (The Excel Addict)
    Guest

    RE: No filter buttons

    Hi Reney,

    I use filters a lot and often encounter the same problem. It drives me nuts.
    I'll try Dave's suggestions next time. Thanks Dave.

    Francis Hayes
    www.TheExcelAddict.com



    "Reney Langlois" wrote:

    > Hi,
    > I'm using Excel 2000. Recent problem. When I try to
    > apply a filter to any table of data, the table header
    > doesn't show the arrow buttons as part of each header
    > cell. There is no error message and when I go back to the
    > Data-Filter menu, the option is selected as normal.
    > Probably something simple but I can't find it. I've
    > rebooted and made simple tables to troubleshoot the
    > problem, but so far nothing.
    >
    > Thanks much.
    >
    > Reney
    >
    >
    >


  5. #5
    Reney Langlois
    Guest

    RE: No filter buttons

    Thanks for the help fellas. I came in this morning, woke
    my computer up from sleep mode, worked for a while, then
    tried the filter cold and it worked just fine. Amazing, I
    tried it at least 10-20 times yesterday after jumping
    through all sorts of hoops and today it starts up.

    Reney

    >-----Original Message-----
    >Hi Reney,
    >
    >I use filters a lot and often encounter the same problem.

    It drives me nuts.
    >I'll try Dave's suggestions next time. Thanks Dave.
    >
    >Francis Hayes
    >www.TheExcelAddict.com
    >
    >
    >
    >"Reney Langlois" wrote:
    >
    >> Hi,
    >> I'm using Excel 2000. Recent problem. When I try to
    >> apply a filter to any table of data, the table header
    >> doesn't show the arrow buttons as part of each header
    >> cell. There is no error message and when I go back to

    the
    >> Data-Filter menu, the option is selected as normal.
    >> Probably something simple but I can't find it. I've
    >> rebooted and made simple tables to troubleshoot the
    >> problem, but so far nothing.
    >>
    >> Thanks much.
    >>
    >> Reney
    >>
    >>
    >>

    >.
    >


  6. #6
    Dave Peterson
    Guest

    Re: No filter buttons

    Frustrating, huh.

    I can't reproduce this at will and it seems when it happens, I'm always in a
    hurry--so I take the quickest and dirtiest way out--which doesn't help for
    future occurrences.

    Reney Langlois wrote:
    >
    > Thanks for the help fellas. I came in this morning, woke
    > my computer up from sleep mode, worked for a while, then
    > tried the filter cold and it worked just fine. Amazing, I
    > tried it at least 10-20 times yesterday after jumping
    > through all sorts of hoops and today it starts up.
    >
    > Reney
    >
    > >-----Original Message-----
    > >Hi Reney,
    > >
    > >I use filters a lot and often encounter the same problem.

    > It drives me nuts.
    > >I'll try Dave's suggestions next time. Thanks Dave.
    > >
    > >Francis Hayes
    > >www.TheExcelAddict.com
    > >
    > >
    > >
    > >"Reney Langlois" wrote:
    > >
    > >> Hi,
    > >> I'm using Excel 2000. Recent problem. When I try to
    > >> apply a filter to any table of data, the table header
    > >> doesn't show the arrow buttons as part of each header
    > >> cell. There is no error message and when I go back to

    > the
    > >> Data-Filter menu, the option is selected as normal.
    > >> Probably something simple but I can't find it. I've
    > >> rebooted and made simple tables to troubleshoot the
    > >> problem, but so far nothing.
    > >>
    > >> Thanks much.
    > >>
    > >> Reney
    > >>
    > >>
    > >>

    > >.
    > >


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1