Expand the range of a pre-existing Pivot Table

[Philosophaie]

How do you expand the range of a pre-existing Pivot Table both at the Pivot Table itself and possibly in VBA code also.

 

[Andrew Poulsom]

In the Pivot Table Wizard click Back at Step 3.

 

[Philosophaie]

I am working in Excel 2010. I know I probably have to delete the current Pivot Table and start a new one to get a new range. I really want to know more on how to work with Pivot Tables and Charts in VBA especially how to delete, insert and select a range would be much appreciated.

 

[RoryA]

Select the pivot table and then Alt+DP should bring up the Pivot Table Wizard, as Andrew said.

 

[ericlowcc]

For Excel 2007, select Pivot Table Option, under Data, select "Change Data Source"