Pivot Chart Formats

Does anyone know a way to freeze pivot chart FORMAT, while allowing data
updates?

On Tue, 30 May 2006, in microsoft.public.excel.charting,
John Francis <John@Francis.?.microsoft.com.invalid> said:

>Does anyone know a way to freeze pivot chart FORMAT, while allowing data
>updates?

It's annoying the way the pivot chart destroys all your carefully chosen
formatting every time it refreshes.

Perhaps, just before you refresh, you could copy the formats to an empty
sheet, then copy them back again onto the pivot table after the refresh?
Perhaps the clever folk who know VBA could even arrange for a macro to
do it automatically?

--
Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.