Copy pivot table and get rid of connection

Hi all.
I am trying to copy a pivot table, but I don't want the formulas and data behind it.
Is there an easy way to do it? I tried copy and cut, but it ends up keeping the data "behind" the table. I just want a "dummy" table to manipulate.

Thx

How about
select the table
edit|copy
edit|paste special|values

araki wrote:
>
> Hi all.
> I am trying to copy a pivot table, but I don't want the formulas and
> data behind it.
> Is there an easy way to do it? I tried copy and cut, but it ends up
> keeping the data "behind" the table. I just want a "dummy" table to
> manipulate.
>
> Thx
>
> --
> araki
> ------------------------------------------------------------------------
> araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
> View this thread: http://www.excelforum.com/showthread...hreadid=519946

--

Dave Peterson

CLOSE! You need to edit-->copy. then paste-->when the dialog box comes up, select VALUE.
VOILA!

MUCHAS GRACIAS, though.

I think going through the menu system should work, too.

araki wrote:
>
> CLOSE! You need to edit-->copy. then paste-->when the dialog box comes
> up, select VALUE.
> VOILA!
>
> MUCHAS GRACIAS, though.
>
> --
> araki
> ------------------------------------------------------------------------
> araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
> View this thread: http://www.excelforum.com/showthread...hreadid=519946

--

Dave Peterson