Pivot Table Issue

[nolanstern]

I have pivot tables set up from a current set of data but I added a new column of data. In doing so, when I select a new range for data source, it does not show the new column of data.

How do I go about fixing this?

Thanks for your help in advance.

 

[Weaver]

You might have to change the range, come out of the wizard and then go back in.

Also, if you have a lot of fields already, your new one might be scrolling off the form in the 'layout' screen. Look for a horizontal scroll bar at the bottom of the screen.

 

[Titian]

After adding a new column to your data set have you "refreshed" the PT?

 

[nolanstern]

I figured it out by refreshing the data in the pivot table and it added the new column...thanks for the quick responses.