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
Bookmarks