Keeping original data format into a Pivot Table

  • Thread starter Thread starter carim.fam
  • Start date Start date
C

carim.fam

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 !!!
 
Not really, Pivot tables are built from the underlying data and all
formatting is lost. You might check out the Format>Autoformat menu options,
but I doubt this will do what you want

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
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 ?
 

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

Playing back a Pivot Table macros 2
pivot table 1
Using VBA on Excel Pivot Tables 3
VBA Pivot Table Error 1
Pivot Tables - Multiple Ranges 9
changing pivot table into a formula table 8
VBA Pivot Table Change Criteria - Help?! 1
Automatically Update a Pivot Table Field Used as Column / Row 1

Back
Top