Hi,

If you have multiple pivot table on a Worksheet, you have to refresh each
table individually, because the source file is different for each pivot table.

Challa Prabhu

"Pivot Tables" wrote:

I need to change the external data source for pivots found on multiple
worksheets within the same workbook. Is there code that I could use to do
this in one click of a button.

Also, how do keep the number formatting for my pivots after I refresh them?
I tried just going to table options and selecting "preserve formatting" and
unselecting "autoformat table" but this doesn't maintain the number
formatting inside the pivot.