Hi,

I have a pivot table with page fields on Sheet1.

In Sheet2 I have data (that is not and cannot be in a table format) which is linked to and calculated by the pivot table in Sheet1.

Is it possible to repeat the pivot table page fields in Sheet1 in Sheet2 (synchronised is fine) so that users can control what they view in Sheet2 whilst on Sheet2.

Many thanks