Pivot Table Adding Columns to Selected Range

I have a pivot table question. I have created a pivot
table that points to a spreadsheet with 20 columns of
data. After creating the pivot table, I needed to go back
and add a column in the middle of the data range. No
problem. However, when I go back to the pivot table
wizard I don't see the additional column. Aside from
deleting the pivot table and starting from scratch, is
there a way for PT to see any additional columns within
the selected range?

John,

You need to refresh the pivot table after adding in the new column. To
do this, click on the pivot table - press the right mouse button and
select the "Refresh Data" option (or click on the ! icon on the pivot
table toolbar. Once you do this, the new column appears in the wizard.

Gabhan Berry
AI Prediction and Forecasting in Excel
<a style='text-decoration: underline;' href="http://www.pececillo.com" target="_blank">http://www.pececillo.com</a>

"John Jost" <anonymous.DeleteThis@discussions.microsoft.com> wrote in message news:<09d601c3ba6e$2292a2b0$a401280a@phx.gbl>...
 > I have a pivot table question. I have created a pivot
 > table that points to a spreadsheet with 20 columns of
 > data. After creating the pivot table, I needed to go back
 > and add a column in the middle of the data range. No
 > problem. However, when I go back to the pivot table
 > wizard I don't see the additional column. Aside from
 > deleting the pivot table and starting from scratch, is
 > there a way for PT to see any additional columns within
 > the selected range?<!-- ~MESSAGE_AFTER~ -->