Timeline for 2010 Excel

[Puggwash63]

I have several worksheets that pull data from a sheet and form Pivots.
I have to change the dates on each Pivot in all the worksheets (eg 04.02.2019) and run the data tab to refresh, so all data needed pulls through.
I know in 2013 Excel, you can create a Timeline, that will change all the dates from all Pivot sheets selected.

Can this be made as I have excel 2010 for work operation?

Thank you

Pugg

[Roel Jongman]

Slicers are available in Excel 2010 and can do also be linked to multiple pivots.
Just the selection of dates might be a bit less user friendly than with the timeline

[Puggwash63]

Many thanks for the comments.

Can the Slicer change all the Pivot dates (I have approx 10 Pivots, that need the same date entering on each one, before refreshing the Data tab)?
Can I pick the date I require and all other Pivots will change, if so hows that done through excel 2010?

Or is there a VBA that can be created, that will auto adjust the Pivots, when the date is chosen from a sheet chosen?

Many thanks

Pugg

[Roel Jongman]

I do not have an excel 2010 copy available to double check but I am pretty sure you can do that with "pivottable connections" when the slicer is active there should be a extra menu that helps you set those connections. I just cant give you exact location of the setting.. been a long time since I used 2010 actively.

[Puggwash63]

Is there any VBA that can do this operation?

[Roel Jongman]

Sure there is but I cannot write that code for you..

Have a look at this site that explains handling slicers with vba and pivottables
https://www.jkp-ads.com/Articles/slicers04.asp

[Puggwash63]

Many thanks,

Read the information for the Slicer VBA and I'm not a good scholar to write the VBA for that.

It would be good if someone out there is possible to help if a VBA is possible for the question I have from the 1st thread

Many thanks

Pugg