Paste values only from a pivot but keep the pivot design when pas.

[dolphin]

I want to paste the values of a pivot table onto another worksheet but want
to keep the same table design, can this be done?

 

[Shane Devenshire]

Hi,

By keep the same table design, do you mean its general look? If so do the
copy, paste values command and then with the destination still selected
choose Edit, Paste Special, Format. (In 2007 this doesn't work.)

 

[Evan Johnson]

As Shane said, we really need to know the exact end result and/or use you are
trying to achieve.

If you truly want the values and the look you can Paste As Picture. This
works in the 2007 version but depending on the data it might be truncated (it
was in my attempt). The main drawback is that it is a picture...you can't
edit it at all but it is useful if you need to use it for a presentation
perhaps?

-Evan Johnson