+ Reply to Thread
Results 1 to 2 of 2

Updating Filtered Pivot Table

  1. #1
    Forum Contributor
    Join Date
    07-02-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    129

    Updating Filtered Pivot Table

    Hi

    I've recently added some filters to some of my PT's in a workbook. My problem is, when new dates are added to the source data the tables don't show that new data unless I clear the filters then re-apply them. This is not ideal with so many pivot tables in the workbook.

    Is there a setting I need to change or some other way of overcoming this problem? The below image shows two of the tables with their filters at the top.

    pt.png

  2. #2
    Forum Contributor
    Join Date
    07-02-2012
    Location
    UK
    MS-Off Ver
    Excel 2003
    Posts
    129

    Re: Updating Filtered Pivot Table

    OK, I've just realised this issue is specifically related to the "Unique" and "Column 1" filters as they are simply filtering out blanks. Is there another way of ignoring blanks in those two columns without using PT filters so the new data will automatically show?

+ 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. Replies: 1
    Last Post: 12-05-2019, 03:47 AM
  2. [SOLVED] Filtered table without using Pivot
    By jrtaylor in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2019, 03:42 PM
  3. [SOLVED] Getting Filtered Pivot table in a Pop-Up
    By BobZZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-23-2018, 10:27 AM
  4. Replies: 2
    Last Post: 12-18-2016, 08:37 PM
  5. Check is pivot table filtered
    By zico8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-13-2016, 02:05 AM
  6. create a pivot table on a filtered table
    By bzl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 06:55 AM
  7. Stop equations updating dynamically when table is sorted/filtered
    By drDanRyan in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-07-2014, 08:10 AM

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