Thread
:
Keeping original data format into a Pivot Table
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nick Hodge
external usenet poster
Posts: 1,173
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 !!!
Reply With Quote
Nick Hodge
View Public Profile
Find all posts by Nick Hodge