Hot To Copy Pivot Table formats

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?
 
S

ShaneDevenshire

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

Dealing with a Pivot Table (when I don't want to) 0
Paste to excel from word - auto format problem 1
Macro to copy table of contents to a new doc 0
Embed the same Excel multiple times 0
Excel does not accept text format! 0
List all tables, including document structure 0
Lose formatting on pivot tables 3
Pivot table report invalid 0

Top