Dear all
I am having 3 pivots in a sheet which is connceted with dates in two different cells eg I2 & K2.
Can any body tell me VBA to refersh these pivots automatically if dates or date in cells or cell is changed.
Dear all
I am having 3 pivots in a sheet which is connceted with dates in two different cells eg I2 & K2.
Can any body tell me VBA to refersh these pivots automatically if dates or date in cells or cell is changed.
Try adding a change event in that sheet's code
![]()
Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
Thanks It works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks