Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping original data format into a Pivot Table
Hi there,
Several users are inputing their own data with specific formats such as Bold, Italic, Color, Underline, etc... When the pivot table is run all of these attributes are lost. Is there a way the pivot table could keep (or even recup with a VBA routine) all of these original attributes ? Thanks a lot !!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping original data format into a Pivot Table
Not really, Pivot tables are built from the underlying data and all
formatting is lost. You might check out the FormatAutoformat menu options, but I doubt this will do what you want -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS wrote in message oups.com... Hi there, Several users are inputing their own data with specific formats such as Bold, Italic, Color, Underline, etc... When the pivot table is run all of these attributes are lost. Is there a way the pivot table could keep (or even recup with a VBA routine) all of these original attributes ? Thanks a lot !!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Keeping original data format into a Pivot Table
Hello Nick,
Thanks for your input. Does it mean that you have already faced this issue, and that you know there is no way out ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table and adding a % column, that is not in original data | Excel Discussion (Misc queries) | |||
Pivot Table - add new group to original data | Excel Discussion (Misc queries) | |||
Original Pivot Table Defaul Format | Excel Discussion (Misc queries) | |||
How do I restore original Pivot Table data? | Excel Discussion (Misc queries) | |||
Keeping original data format in a pivot table | Excel Programming |