change pivot table source data using vba

[p4nny]

Hi,

I would like to change the source data of my pivot table, from one location to another.

The new data is in a different location.

appreciate any guidance

Thank you

 

[Domenic]

The last code that you posted compiles without an error. Although, you now say that you've placed the code prior to SaveAs. In that case, you'll need to post the exact code that you're using in order to debug it.