Is there any way to link the chart appearance as well as the values when I do
a copy and paste of a chart in excel from one workbook to another? Currently
the values change automatically but if I change the chart style in the source
chart the destination charts don't get this.

The other alternative is to link the chart through OLE but excel does not
seem to allow me to link it under paste special (it is greyed out) unlike the
other office apps (word, powerpoint).

Thank in advance for your help