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?