Ian has attended:
Excel Advanced course
Timelines
IS it possible to link two pivot tables to 1 timeline, if so how?
RE: Timelines
Hi Ian,
Thank you for the forum question.
Yes you can control any number of pivottables from a timeline.
Select the time line and click Report Connections/PivotTable connections on the Options tab in the Time Line group.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Timelines
Thanks Jens
When I try that I only get reported connections, I don't get the option of managing them.
Kind Regards
Ian
RE: Timelines
Hi Ian,
I can understand that you have Excel 2013 or 2016. In these two version you have Report Connections. If you have the TimeLine selected and click on Report Connections you should be able to see all PivotTables created from the same source data.
If your PivotTables are created from multiple PivotCaches (Multiple data sources) you cannot filter them from the same data source.
I hope this is helpful.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
