View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
muddan madhu muddan madhu is offline
external usenet poster
 
Posts: 747
Default 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.