updating a pivot table's original data sheet
 

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

updating a pivot table's original data sheet
 

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

updating a pivot table's original data sheet
 

On Feb 28, 2:18*pm, AB wrote:
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

Brill - was in 2003 - job done thanks.

John