S Shay A Member Jul 6, 2017 #1 Hi, How can I make items that no longer exist in tha data source to be removed from the drop down in the pivot table? TY, Shay
Hi, How can I make items that no longer exist in tha data source to be removed from the drop down in the pivot table? TY, Shay
Chihiro Excel Ninja Jul 6, 2017 #2 In PivotTable Options. Go to Data tab and set "Number of items to retain per field:" to None.
S Shay A Member Jul 6, 2017 #3 thank you, and what if I have a field that was deleted from source data? It will be retained as well? Shay
thank you, and what if I have a field that was deleted from source data? It will be retained as well? Shay
S Shay A Member Jul 6, 2017 #4 and about the items again, if the item was placed in the source data, will it appear again in in the pivot table? TY
and about the items again, if the item was placed in the source data, will it appear again in in the pivot table? TY
Chihiro Excel Ninja Jul 6, 2017 #5 Fields should disappear when you refresh your PivotTable, without any setting.
Chihiro Excel Ninja Jul 6, 2017 #6 And yes. Pivot will always update with what is contained in source data when refreshed (item or otherwise).
And yes. Pivot will always update with what is contained in source data when refreshed (item or otherwise).
