Hi Excel Experts,
Can anyone help me to edit the below code to allow refresh all pivots on the same worksheet upon changes on Month filter only, please? At the moment this code I found will refresh all pivots on same worksheet upon changes on any filter.
Appreciate your help.
Thanks in advance.
Please Login or Register to view this content.
DZ
Hi,
I don't believe you can directly determine which filter has been changed but testing the previous value of the month filter should serve as a workaround
Please Login or Register to view this content.
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi xlnitwit , your edited macro doesn't seem to work.
Might you provide a workbook demonstrating what happens, please? I did test the code prior to posting it and it worked well. Additionally, a little more detail than doesn't seem to work would be useful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks