I am using an external data source for my pivot table data. I added/deleted a few columns of data, so for excel to recognize these changes, I take the following steps: Right click in pivot table, select "PivotTable Wizard", press "Back", press "Get Data", I then run a new query to completely reselect the data. I return the newly selected data to the table, and wait a minute for excel to load the data. However, when all of this is complete, the new data is not there; it's still referencing the old data. Am I doing something wrong?