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