Any custom formatting is lost when a pivot chart is
refreshed and although it's possibe to write a macro to
reformat it has to be triggered with a button or key
stroke.

Unlike Access there don't seem to be any event properties
for a pivot chart field button so is there another way to
have the macro run whenever the field button is refreshed?

Thanks

Mike Collard