PivotTable field does not refresh with "Refresh All"

Question

Hi, I created couple of PivotTable on Excel, I made change with few name on the dataset. However, the PivotTable field is keeping the old name as well as the new name. I clicked "Refresh All" only the data being refreshed but not the field name.

How can I refresh the field name list on the PivotTable and get rid of the old names?

Answer 1

Resolved - PivotTable Options_ Number of items to retain per field - None

Answer 2

Hi @Tang, Angel

I am glad that you find this option to resolve your issue, and thanks for your kind sharing.

By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.", and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would make a brief summary of this thread:

Issue Symptom:

After change few names on the dataset, the PivotTable field is keeping the old name as well as the new names, "Refresh All" does not work. No way found to get rid of the old names.

Current Status:

Solved by Tang, Angel.

• Right-click on the pivot table > Select "PivotTable Options".
• Set "None" for Number of items to retain per field.
• Right click on the pivot table, click "Refresh".

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---