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



carolyn wrote:
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?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html