| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
