I kind of agree with sam on this, and dont think that there is a way
by which any other pivot table will get effected by changing the value
of one pivot table. If you often apply filter on the same kind of
data, then you can always use the SLICERS in Excel, which should
definitely solve your concer
Each pivot table is linked to the other pivot table only through the pivot
cache, and that too if they are using the same source. There is no way in
Excel where you can filter one pivot table, and have the other pivot tables
also to get filtered.
The best you can look at is to have a sub routine c
Dear Lional,
Can you share any sample workbook with excel macro group.
On Wed, Feb 1, 2012 at 3:27 PM, lional deo wrote:
> Hi Friends,
>
> This is lional and I am in need of a help.
>
> I have to prepare five different pivots for a single data set.
>
> in order to get the data in required forma
