+ Reply to Thread
Results 1 to 5 of 5

Pivit Table not Filtering???

  1. #1
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Pivit Table not Filtering???

    Using Excel 2010. I've inserted Field Headers but their drop-down filters buttons don't work. However, if I insert data filters in the empty row above, these filters work just fine. Any ideas as to what I'm doing wrong?

    Thanks. David

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Pivit Table not Filtering???

    Hard to say without seeing what have
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Re: Pivit Table not Filtering???

    It's proprietary, sorry to say. And large, otherwise I would reproduce it, "scrubbed". I was just wondering if this is a common problem and, if so, what are some of the usual suspects....Any suggestions are welcome! Thanks. David

  4. #4
    Forum Contributor
    Join Date
    05-23-2014
    Location
    Fredericia, Denmark
    MS-Off Ver
    Windows Office 2013, Excel 10
    Posts
    139

    Re: Pivit Table not Filtering???

    Problem seems solved now. I clicked on a cell in the empty row above to insert the filters (which worked previously) and lo and behold filters appeared in the non Field Header columns and all filters now work. Not sure what's going on.... but I'll take it! Thanks. David

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,049

    Re: Pivit Table not Filtering???

    Glad you got this resolved, and thanks for sharing with us

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] how can i sum pivot table filtering some values another table
    By moogii1102 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-19-2014, 02:17 AM
  2. Filtering a table based on current cell in another table
    By bobarnett in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-02-2013, 10:44 AM
  3. Filtering Table B by the results in a column of Table A
    By GreenTee in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2013, 10:10 PM
  4. VBA and filtering table
    By brncao in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-19-2012, 03:53 AM
  5. Pivot Table Filtering
    By kavkazi in forum Excel General
    Replies: 2
    Last Post: 11-16-2010, 11:06 AM
  6. VBA Pivot Table Filtering
    By datawrecker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-03-2010, 09:44 AM
  7. [SOLVED] pivit table will not caculate
    By Mike in forum Excel General
    Replies: 1
    Last Post: 03-28-2005, 06:06 PM

Tags for this Thread

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