Hello,
i'm looking for a dynamic VBA script which looks through all sheets for a chart and stores the colors. Refreshes the pivot chart and the re-applies the colors.

Does anyone have anything as such handy?