Improve company productivity with a Business Account.Sign Up

x
?
Solved

Pivot table does not forget previous pivotitems

Posted on 2013-11-25
2
Medium Priority
?
269 Views
Last Modified: 2013-11-25
I have a set of data containing projects A, B, C, D.
From here I generate a pivot table which contains all four projects.
When I get new data containing projects C, D, E, F in the same place and then update the pivot table then the pivotitems are A, B, C, D, E, F. Somehow the pivot items A and B do not disappear.

I have tried refresh and change data source.

Is there some other way to do this?
0
Comment
Question by:Saqib Husain, Syed
2 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 2000 total points
ID: 39675207
Debra has instructions for how to clear out the old items in various versions on her site here: http://www.contextures.com/xlPivot04.html
0
 
LVL 12

Expert Comment

by:Harry Lee
ID: 39676390
ssaqibh,

You can right click on the pivot table, and choose, PivotTable Options.

Goto Data tab, and change the Number of items to retain per field: from Automatic to None.

That will force the PivotTable to show only field data that currently exist in the Data.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question