Can anyone help?

I have a workbook with c. 300 charts and 50 sheets it is running at 30 megs.

I don't want to split into into seperate books and the charts are very format hungry as they need to look good and go into published research.

Every now and then I need to copy a chart with its formatting to create 1 or several new charts. I get the "No more fonts may be applied to this workbook" message.

I have looked at many threads suggesting to switch off the Autoscale (eg http://support.microsoft.com/default...b;EN-US;168650) but that is already switched off - the problem is the limit of fonts is soo low in Excel 2003 (I know its better in the latest version). Does anyone know of a macro or tool that reduces the number of fonts by eliminating duplicates (as excel seems to double count the same fonts in 2 different charts)? I have a great tool for format styles but not fonts.

Any ideas?