Refresh one pivot table at a time

[Disc_So]

Hi!

I have a Table with an ODBC connection and from that table, I have multiple sheets with "Pivot tables" (with their respective "Dynamic Chart").
What I want is to change the query and then refresh just one Pivot table at time, but when I refresh one Pivot table all the “Pivot tables" refreshes.
I think the problem is that all the Pivot tables have the same data source.

What can I do?

Sorry for my poor English, and Thanks!

 

[mole999]

if you give a pivot a name, then record a macro as you do a refresh on it you should be able pick out the working bits

 

[Disc_So]

if you give a pivot a name, then record a macro as you do a refresh on it you should be able pick out the working bits

I already try it and it doesn't work, all the pivot tables are refreshed.

 

[mole999]

with ActiveSheet
.PivotTables("PivotTable1").PivotCache.Refresh
.PivotTables("PivotTable2").PivotCache.Refresh
end with

 

[Disc_So]

with ActiveSheet
.PivotTables("PivotTable1").PivotCache.Refresh
.PivotTables("PivotTable2").PivotCache.Refresh
end with

I already tried that and it didn't work.
All the PivotTables have the same PivotCache, that's the problem.