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?

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?

If regular worksheet cells are included in the copied range, the pivot
table formatting won't paste onto the copy.
As a workaround, you can do the following:

Copy the entire pivot table, and paste it as values.
Then, copy the body of the original pivot table, and paste it as formats
on the body of the copy.
Copy the report filters (one at a time), and paste as formats on the
report filters in the copy.

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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html