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.