Pivot Tables - Change source from internal to external

[rory]

Thanks Rory, but I think the Update method only changes/updates the pivotfields settings and properties and the pivottable layout (which fields are row, column, page, etc).

Yes, that's what I said. :)