Edit Pivot Query in Code
 

Hi all I have a pivottable using a database but the database has been moved I
am trying to change the sql of the pivot but it's greyed out, I am trying to
do it in code I can creat a pivot but not change the source.
TIA
Charles