Refresh one pivot table at a time

Disc_So

New Member
Joined
Mar 27, 2014
Messages
4
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!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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

New Member
Joined
Mar 27, 2014
Messages
4
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

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
Code:
with ActiveSheet
.PivotTables("PivotTable1").PivotCache.Refresh
.PivotTables("PivotTable2").PivotCache.Refresh
end with
 

Disc_So

New Member
Joined
Mar 27, 2014
Messages
4
Code:
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.
 

Forum statistics

Threads
1,181,854
Messages
5,932,452
Members
436,839
Latest member
Mama247

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top