Hi,

Is it possible to use a cell reference in a PivotTable filter? I have a document with a number of sheets whre I use Pivot Tables, diagrams and slicers to provide data analysis to my colleagues. By using a cell reference I could update all Pivot Tables at once.
Can this be done? If so, how?
thanks