Making a pivot table report static.

I

ideal

Using Excel Professional 2003. Is there a way to make a pivot report a
static report other then copying the sections you want to another sheet?
 
D

Dave Peterson

select the pivottable
edit|copy
edit|paste special|values
(right in it's original location???)
 
Top