View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TM
 
Posts: n/a
Default Refresh PivotTable, lose custom cell formatting

I am using Excel 2003. I see several posts about losing custom cell
formatting. They refer to the setting "Preserver Formatting". This works
well when the data source is from an Excel worksheet. However, I can not
preserve formatting after a refresh when the data is from an external data
source.

Any help would be appreciated,

-TM