1.. Right-click a cell in the pivot table
2.. Choose PivotTable Wizard
3.. Click the Back button, and select the new range
4.. Click Finish.
"PJ" wrote in message
...
Hi All

Is there any way that I can change the source data range after the pivot
table has been created, without having to do a new sheet.

I.e. Curent range is A1:D25

Want to amend to A1: F1000

Cheers

Paul T