Converting to a static repot

C

carolyn

I have created a pivot table and now before I send it to others I would like
to strip out the pivoting funvctionality so that all they see is a static
report. Is this possible?
 
D

Debra Dalgleish

Copy the pivot table
Create a new workbook, and select the cell where you'd like to
paste the pivot table
Choose Edit>Paste Special, select Values, click OK
Choose Edit>Paste Special, select Formats, click OK
 
Top