PIVOT TABLE-SOURCE RANGE

P

Pam M

Is there any way to edit the source range of a pivot table? I don't want to
have to recreate all of the formatting etc.
 
R

Roger Govier

Hi Pam

Depends upon the version of XL for the answer.
XL2003 and earlier
Right click on PT>Back>edit Source

XL2007
Whilst on PT>Options tab<>Data group>Change Source
 
P

Pam M

You are the best! Thank you!

Roger Govier said:
Hi Pam

Depends upon the version of XL for the answer.
XL2003 and earlier
Right click on PT>Back>edit Source

XL2007
Whilst on PT>Options tab<>Data group>Change Source
Click to expand...
 
Top