View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ad. 83 Ad. 83 is offline
external usenet poster
 
Posts: 1
Default Pivot table format on paste values

Hi,
I've constructed a working file with numerous pivot tables to be used in
reports. what i would like to do is paste these sheets into a new book as
values and still retain the Excel 2007 formats. As i have multiple pivot
tables on one worksheet when i copy and paste into the new sheet i lose all
the pivot table formatting eg total lines and the standard blue headings?
it seems i can simply highlight one pivot and copy and paste this as values
and source formats but it does not work when copying the whole sheet - which
i need as this is a very repetitive task if i have to reformat everything
each time.
Any ideas, how i can get round this?

Cheers

Ad.