How to change Pivot when SQL data source fieled name changed

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

Guest

Resolution: Call up the "Pivot Table Wizard" and hit Back Button to retrace
steps and change data source
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top