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

"dolphin" wrote:

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?