How to change excel 2007 pivot table data source to another pivot table?

[blueycool]

Hi,

I have a pivot table A created in Excel 2003 with the data source linked to another pivot table B. How do I change the data source of pivot table A link to a new pivot table C in Excel 2007? Can Excel 2007 create/change pivot table with data source link to another pivot table? I can't seem to find any function for that under Excel 2007 Pivot table commands. How do I resolve this? Please help.

Thanks!! <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[andrewman]

add an icon from excel option.

 

[Andrew Poulsom]

If you select the same data source before creating the pivot table Excel will automatically use the same pivot cache. If you want, you can activate the Wizard With Alt+DP.

 

[blueycool]

Hi all, thanks..
Manage to solve my problem..I use the wizard to change data source to another pivot, as what I did in Excel 2003 last time.

Thanks for help!