I have one Slicer Timeline that I use for multiple pivot table reports (each of which is on a separate worksheet).
What I do is simply copy the slicer timeline onto the Reports worksheet and then, using VBA, change the Report Connection to the respective pivot table for that report.
This works fine but the problem I'm running into is the name of the "Date" field in my pivot tables varies:
Date, Date Listed, Date Sold
I'm looking for VBA code that removes the existing Date SourceField in the timeline slicer and updates it to use the Date SourceField used in the target pivot table.
Is this possible? If so, kindly provide a code sample.