any way to copy and paste values from pivot table and keepformatting?
 

I'd like to copy and values from a pivot table and paste them to a new
workbook in a way where the formatting remains. Does anyone know how
to do this? I have excel 2003.

any way to copy and paste values from pivot table and keepformatting?
 

copy pivot table | paste special | click values | ok


On Apr 8, 6:46*am, eggman2001 wrote:
I'd like to copy and values from a pivot table and paste them to a new
workbook in a way where the formatting remains. Does anyone know how
to do this? I have excel 2003.

any way to copy and paste values from pivot table and keep formatting?
 

After doing this
copy pivot table | paste special | click values | ok
just right-click on the paste & do a paste special | click formats | ok
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

any way to copy and paste values from pivot table and keepformatting?
 

How do I 'copy pivot table'? Select All | Copy ?

If I do Paste Special in a new workbook, it tries to link the paste
back to the original workbook, which I don't want.

On Apr 7, 10:27 pm, "Max" wrote:
After doing this copy pivot table | paste special | click values | ok

just right-click on the paste & do a paste special | click formats | ok
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---

any way to copy and paste values from pivot table and keep formatting?
 

Select the pivot/parts thereof*, then click Edit Copy (from the menu
command) to copy,
then do the paste special as values & as formats
*either manually (for parts) or via right-click inside the pivot Select
Entire Table
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"eggman2001" wrote in message
...
How do I 'copy pivot table'? Select All | Copy ?

If I do Paste Special in a new workbook, it tries to link the paste
back to the original workbook, which I don't want.