LinkBack URL
About LinkBacks
There is a rich selection of vba code to deal with pivot tables. Try doing what you are doing while recording a macro and see what you get.
Re: Auto update pivot table filter dates
There is a rich selection of vba code to deal with pivot tables. Try doing what you are doing while recording a macro and see what you get.
Turn Data into Information
Turn Information into Knowledge
Turn Knowledge into Direction
Turn Direction into Leadership
Turn Leadership into Results
Stephen Druley
It's not how quickly you think
But how deeply you think
The quality of thinking is measured
by remoteness to conformance
Stephen Druley
Will the macro be able to check the new dates in a filter?Originally Posted by SDruley
I have already edited the pivot tables so that the source automatically includes the new data without needing to edit the source on the individual table. I just want to be able to automatically edit the filters as well.
Re: Auto update pivot table filter dates
Refreshing the pivot either programmatically or manually will bring the new dates into the pivot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks