Converting to a static repot
 

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

Converting to a static repot
 

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

Converting to a static repot
 

Thanks. This is exactly what I was looking for
--
carolyn


"Debra Dalgleish" wrote:

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