PDA

View Full Version : Change all pivot table data sources



King5555
03-28-2011, 07:38 AM
Hello all-

I have a workbook with dozens of pivot tables that link to a table in a data sheet. I want to change them all to point at another table in another sheet. I tried recording myself changing one of them but the recording didn't capture that. Is there a way to cycle through all pivot tables and programmatically change the data source?

Thanks for the help!