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


--
araki
------------------------------------------------------------------------
araki's Profile: http://www.excelforum.com/member.php...o&userid=15334
View this thread: http://www.excelforum.com/showthread...hreadid=519946

Copy pivot table and get rid of connection
 

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

Copy pivot table and get rid of connection
 

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

Copy pivot table and get rid of connection
 

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