I have created a chart type which I have named 'SERA STYLE'.

I also have created a macro that automatically formats the output of a pivot table such that whenever the pivot table is updated, the associated pivot chart maintains the same format (SERA STYLE).

The problem I have is that when another user accesses the file from the server and updates the pivot table, they get an error message as a result of the macro not being able to run through (it stops when it gets to "SERA STYLE". This is because they do not have SERA STYLE saved in their version of Excel (2003).

Note that when they first open the file the chart appears with SERA STYLE prior to them updating the table.

My question is whether there is any way to have this chart type added to their user defined chart types when they open the file for the first time?

Here is the code that automatically formats the chart:

Please Login or Register  to view this content.
Many thanks,
Carl.