Formatting - Calculated Field in Pivot Table.

I have a report that I am creating using a pivot table. Everything works great except formatting. The pivot table can be expanded and contracted to drill down into different layers and when this happens, formatting issues arise. To combat this, I use a button to run the macro at the bottom to derive the formatting from the source data. Unfortunately, there are calculated fields that do not have source data, and thus the formatting is still an issue.

Two questions:

How can I best fix the calculated field formatting issue?
Is there an event I can tie the macro to that will run if fields are expanded or contracted?

Thanks,
Kurt

Please Login or Register  to view this content.