+ Reply to Thread
Results 1 to 3 of 3

Pivot Table still has old values in filter fields

  1. #1
    Registered User
    Join Date
    08-19-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2010
    Posts
    6

    Pivot Table still has old values in filter fields

    I have an excel sheet which I'm turning into a template, so I deleted all the raw data out of the sheet and refreshed my pivot table.
    The table appears blank now but if I select to filter a field the old data is still shown. So I added new data to see if it would go away but it didn't.
    It added the new data to the filter field along with the old data.
    I even deleted the pivot table and created a new one with the blank table and the old data is still shown in these filter fields.

    Below is a picture of the new pivot table I just made, you can see the data fields are blank but the filter fields still show values and they will not disappear.

    If anyone can help that would be greatly appreciated.

    Capture.PNG

  2. #2
    Registered User
    Join Date
    10-28-2008
    Location
    Turkey
    Posts
    88

    Re: Pivot Table still has old values in filter fields

    Follow these steps.

    1.Right-click a cell in the pivot table
    2.Click on PivotTable options
    3.Click on the Data tab
    4.In the Retain Items section, select None from the drop down list.
    5.Click OK
    6. Refresh the pivot table.

  3. #3
    Registered User
    Join Date
    08-19-2016
    Location
    Pennsylvania, USA
    MS-Off Ver
    2010
    Posts
    6

    Re: Pivot Table still has old values in filter fields

    Thank you! I could not figure this out this was exactly what I needed.

+ 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. Looping through in Pivot table Filter fields
    By zsirsaman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2016, 09:31 AM
  2. Pivot Table - Add Multiple Fields to Values Tab
    By Shadefalcon in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-23-2014, 05:40 PM
  3. Existing pivot table and dropping new fields in Values
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-02-2013, 10:55 AM
  4. Counting the number of Selected Fields in a Pivot Table Filter
    By adoepker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-09-2011, 11:53 AM
  5. Pivot Table filter with added fields?
    By rbpd5015 in forum Excel General
    Replies: 3
    Last Post: 08-17-2010, 02:10 PM
  6. How to pull values from the pivot table fields, through the code/.
    By seven_snow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2006, 07:50 AM
  7. How do I set up filter for page fields in pivot table?
    By Mitsycat in forum Excel General
    Replies: 3
    Last Post: 05-06-2005, 06:06 PM

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