If you're on XL2003 - right click into the pivot, goto
PivotTableWizard Back. Then select your range.
In XL2007/2010 - i think it's one of the Ribbon options when Pivot is
active.

On Feb 28, 11:44*am, Johnnyboy5 wrote:
Hi

How do I update the "data" that a pivot table is currently using - if
I have made changes to the "main sheet" *eg. added a new column in
which I want to use the data for that pivot table.

thanks

John