Hi

mark the PTCopyPaste SpecialAll using Source Theme

--
Regards
Roger Govier



"kswan" wrote in message
...
In office 2007 I am unable to copy a pivot table and "paste special"
values
and formats as I could in office 2003. I want the text, borders and
shading
from the pivot table to copy over but not the entire pivot table. In
Excel
2003 this was done by copying and then "paste special" "values" and then
"paste special" "formats". Any clue how to do this in '07?