pivot tables


M

Mike

So in 2007, I have two pivot tables that reference the same data set and have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any solution/suggestion
is welcomed.

Thanks for any help.
 
Ad

Advertisements

M

Mike

Anyone got any help that doesn't cost anything?

trip_to_tokyo said:
Yes, you seem to want, "Synchronizing Two Pivot Tables with One Combo Box"
covered in detail in pages 225-229 of Pivot Table Data Crunching by Jelen /
Alexander.
 
D

Don

how about creating VB code that you can have a button ?

ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
ActiveSheet.PivotTables("PivotTable2").PivotCache.Refresh
 
Ad

Advertisements

R

Roger Govier

Hi Mike

Debar Dalgleish has some examples in her download at
http://www.contextures.com/PivotMultiPagesDiffChange.zip

--
Regards
Roger Govier

Mike said:
So in 2007, I have two pivot tables that reference the same data set and
have
the same report filters. Is there a way to set it up so I only have to
change the report filter selection on one pivot table and the data will be
updated in both? I am fairly comfortable with VBA so any
solution/suggestion
is welcomed.

Thanks for any help.

__________ Information from ESET Smart Security, version of virus
signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4830 (20100203) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top