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
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 format, I have to keep changing master
data. Now I just want to know is there any way to link the pivots so that
If I make any changes in the
