How to change Pivot when SQL data source fieled name changed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Q: How to change Pivot when SQL data source field name changed

I have a Pivot table that accesses a SQL data source.

When one of the Fields Names in SQL is changed there is an error when trying
to refresh Pivot Table.

I cant find a way to edit the Pivot Table MS Query for the new SQL Columns
Name like I can when just using MS Query to import data into excel vs into
Pivot.

Is this possible?
 
Resolution: Call up the "Pivot Table Wizard" and hit Back Button to retrace
steps and change data source
 
Back
Top