Hi,

Q1. It sounds like you already know how to use Paste Special, Values on a
pivot table, so what's the question?

Q2. Select a range with the pre-defined format and double-click the Format
Painter, then move to each sheet and paint the valued-pivot table range.

Q3. You can add data validation to any regular spreadsheet cell including
the valued-pivot table.

--
Thanks,
Shane Devenshire


"Singh" wrote:

Subsequent to using the 'show pages' function on a pivot table, I have a
workbook with multiple worksheets of pivots.

I would like to paste-special values on all worksheets so they can no longer
be manipulated by the pivot. Then copy a pre-defined format to all
worksheets.

Bonus question: Would it be possible to systematically add data validation
dropdowns to the first two columns of each of these newly created worksheets?

Any help would be greatly appreciated.

Thanks,
Singh