Single Set
multiple pivot tables controlled by a single set of page fields to automatically update all tables?
Hi,
Is it possible in Excel to update multiple pivot tables, all using the same page fields, by changing the page fields just once instead of having to change them for each table?
Thanks
Sure
When you build the pivot tables, make them reading the values from that source table
Once you update your fields, you may need to refresh each pivot table, or use the macro to make updation for all you pivot tables like this
ActiveSheet.PivotTables( “PivotTable1″).PivotCache.Refresh
All you need to add is a loop through all your sheets with pivot tables and refresh each one
For i=1 to ThisWorkbook.Worksheets.Count
Worksheets( i).PivotTables( “PivotTable1″).PivotCache.Refresh
Next i
Also you may need to make sure that each Pivot is named “PivotTable1″ in each sheet
VBAXLMan is back to feed your Excel needs
|
|
Bayou Classic SP10 High-Pressure Outdoor Gas Cooker, Propane $22.99 Even if the breeze off the lake is strong, the High-Pressure Outdoor Cooker maintains a steady flame. A 360-degree windscreen, 10 psi preset pressure regulator and brass control valve ensure that the flame stays consistently blue and strong so that your cowboy stew will cook evenly. The heavy-duty welded steel frame features double support legs and wide tripod design, keeping the unit stable on un… |
|
|
Bayou Classic SQ14 Single Burner Outdoor Patio Stove $44.99 13 inch tall heavy duty steel frame. Large 16 inch x 16 inch cooking surface. Ul-listed 3 ft. High pressure hose and regulator kit. Widest range of flame control. Accommodates any size stockpot. Maximum BTU output of 55,000. LP only!… |
|
|
Riedel Vinum Single Malt Whiskey Glasses, Set of 2 $35.00 Renowned Austrian glassmaker Riedel designs the shape of each glass to most fully enhance the appreciation of the liquid within. Seeking the expertise of master distillers in Scotland, Riedel came up with its definitive single malt whiskey glass: a deep bowl on a short, pedestal stem. With its flared lip and curved profile, one can even imagine the bowl resembling a Scottish thistle. Perfect for a… |
|
|
Sugarland – Live on the Inside (CD+DVD) $10.00 Sugarland – Live on the Inside (CD+DVD)… |
|
|
Wanderlust [Deluxe Single Set] $21.04 Wanderlust [Deluxe Single Set] |
|
|
Whirlpool 308957T Knob,Single Set Button $10.67 Knob,Single Set Button |
