How to change the Excel data table header name?
If you want to change the data table header name.
Change the required header name, for example change (Sales) to (Income)
Go to Data Menu > Click on Refresh All
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,So, you must add Income to the value's field