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

"Nodak" wrote:

> 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?
>