Share via

Repeat the source format in pivot table

Anonymous
2010-09-08T01:58:27+00:00

Hi, I have a spreasheet with different measures and kpi's. The measures are formatted differently and I want to report via a pivot table, but in the pivot the format default to one format only. Are there a way that I can keep the different formats as displayed in the sheet?

Thanks

Hennie

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2010-09-08T09:24:44+00:00

Hi

The Pivot Table does not retain any formatting from the source data.

The data is held in a pivot cache, which has no formatting at all.

You will need to create the formatting of the PT that you want, and then on PT Table Options, uncheck the Autoformat feature.

Regards

Roger Govier

"HJoubert" wrote in message news:*** Email address is removed for privacy ***...

Hi, I have a spreasheet with different measures and kpi's. The measures are formatted differently and I want to report via a pivot table, but in the pivot the format default to one format only. Are there a way that I can keep the different formats as displayed in the sheet?

Thanks

Hennie

________ Information from ESET Smart Security, version of virus signature database 5430 (20100907)________

The message was checked by ESET Smart Security.

http://www.eset.com

________ Information from ESET Smart Security, version of virus signature database 5430 (20100907)________

The message was checked by ESET Smart Security.

http://www.eset.com

Roger Govier Microsoft Excel MVP

Was this answer helpful?

1 person found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest