Pivot table copy and pasteing

K

kswan

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

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
excel 2007 pivot table: how to paste special formats? 2
Pivot Table cell values 1
Doughnut Chart linked with the slicer in the pivot table 0
Pivot table format on paste values 0
pasting values from pivot table still linked 0
Additional columns for Pivot table 0

Top