How do I keep my own formatting for a pivot-chart on refreshing
 

I have many pivotcharts which need to be continually refreshed to represent
statistics from data within the workbook. I need to display these charts with
my own colour scheme - however the charts are refreshed they revert back to
the dodgy Excel default colours.

To complicate matters further they are part of a shared workbook - so my
macro I recorded to re-apply my colour scheme doesn't work.

Can anyone help????