How to change the Excel data table header name?

If you want to change the data table header name.

Step 1

Change the required header name, for example change (Sales) to (Income)

Step 2

Go to Data Menu > Click on Refresh All

Step 3

Must re-add the new header name to the correct field in the pivot table

In the below example, here the Type has been added in the row's field,

and the Sales in values field.

But after changing the name of the header from Sales to Income, the Sales will  removed from the values field,