excel - Is there a way to use a single cell as a date reference for numerous PivotTable date fields?

Question

I have several PivotTables which all pull data for a date that I specify.

The issue is that I need each PivotTable to show me data relevant to the same date.

As such, I have to go through each PivotTable (around ten in total) and manually change every date to the one I need to scrutinise.

I understand the complexities involved - i.e. each PivotTable having it's own reference table and thus one simply can't change the value of the PivotTables' date cells to pickup the value of another (external) cell - which leads me to my question:

Is there a way to use a single field - one which is external from all of the PivotTables - where I enter the date I need and subsequently have all of the PivotTables' date fields pick that date up as the one to use?

question from:https://stackoverflow.com/questions/65883485/is-there-a-way-to-use-a-single-cell-as-a-date-reference-for-numerous-pivottable

Answer 1

Waitting for answers