Problem copying pivot values to new workbook

[Alpacino]

Hi
I can't seem to copy values from a picot table to another workbook anyone help.

Thanks

 

[crook_101]

Hi,

Just guessing here but are you right clicking on the pivot table?? If so the copy option is not there.....

Highlight the area to copy, press "Control" & "C", go to area where you want to paste the data andpaste special as values.

If this is not what you mean, please post back.

Regards,
Ian