Prev: Calculating How Old Someone Will Be in a certain year
Next: Lost functionality to copy a formula across rows
From: Ad. 83 Ad. on 21 Mar 2010 11:04
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.
 | 
Pages: 1
Prev: Calculating How Old Someone Will Be in a certain year
Next: Lost functionality to copy a formula across rows