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.