Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hot To Copy Pivot Table formats
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? -- Thanks, David |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hot To Copy Pivot Table formats
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. -- Cheers, Shane Devenshire "DavidA" wrote: 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? -- Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy a pivot table and "paste special" formats in excel 07 | Excel Discussion (Misc queries) | |||
pivot table formats | Excel Discussion (Misc queries) | |||
Pivot Table - Formats Reset... why? | Excel Discussion (Misc queries) | |||
Dates Formats in Pivot Table Help | Excel Worksheet Functions | |||
Pivot table formats | Excel Discussion (Misc queries) |