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!
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!