• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Pivot table options changed after the creation of pivot table, how to refresh and delete the not need

luiscoutinho

New Member
Hi there,

I create a pivot table where I have lots of options, but then I decided to eliminate some of that options, but now each time I make the filter option, all the options from when I created the pivot table are there, although in the database of the pivot table they were deleted and no longer live there. How can i put to appear only the option that are available in the database separator?

66553
 
Hi, I believe with "Options" you refer to the items (values) in the filter list.

If that's so, you can eliminate the values that are no longer present in your data by setting "None" in the Data options as shown below.
66554
 
Back
Top