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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lose formatting on pivot tables 3
using GETPIVOTDATA feature and need to keep formatting 1
Pivot tables after Excel 97 2
Pivot Table Defaults 1
Pivot table report invalid 0
Workbook pivot table design function 6
Pivot Table Calculations 2
Pivot Table - copy specified Grand Totals 1

Back
Top