|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 23rd, 2008, 07:55 PM
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
January 23rd, 2008, 10:03 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
