Hot To Copy Pivot Table formats

  • Thread starter Thread starter DavidA
  • Start date Start date
D

DavidA

In Excel 2007 I want to copy and paste special, both values and formats, from
a pivot table into a new worksheet. The values copy and the values are
formatted, but the sytles do not copy overs. Any ideas?
 
Hi David,

Pivot Table styles are associated with the Elements of the pivot table, when
you convert a pivot table to a regular range you loose all the PivotTable
Styles stuff. Only manual formatting will remain.

This is not a bug, and you're not loosing your mind, but if you think about
it you will see why.
 
Back
Top