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.

copy pivot table | paste special | click values | ok


On Apr 8, 6:46*am, eggman2001 <sod...@gmail.com> 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.

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
---

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" <demecha...@yahoo.com> 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
> ---

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" <(E-Mail Removed)> wrote in message
news:c3ec4ba5-63b0-409a-98c8-(E-Mail Removed)...
> 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.