How to refresh a specific Pivot Table if data in another Pivot in the same worksheet has been changed

gilsa

New Member
Joined
Sep 16, 2014
Messages
21
Hi,
I am trying to use VBA to automatically refresh a specific pivot table which is based on another table which the last based on another pivot table.
All data resides in the same worksheet.
Once the first pivot is being changed the table of course get updated but the pivot which is based on doesn't.
How can I do so?

Thanks,
Gil
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,108,507
Messages
5,523,309
Members
409,510
Latest member
HQ2401

This Week's Hot Topics

Top