Whle I don't expect to have this problem, I am curious. Having to fix this in the registryy sounds drastic, but if it must be for a large workbook already in existence, so be it.
Changing all existing charts can be a big job if there are many, though writing a macro to do it ain't so bad.
.
However...
The KB doesn't say, but what if you create the first chart with the auto-scale off (in Excel as described in the KB), then copy the chart (assuming you want an identical chart, or almost so), then simply change the referenced ranges for the new chart.
If you have several types of charts perhaps you only have to do this for each type and do the copy/modify thing for each addional version for each type.
eh?
Steve
--- "david braithwaite" wrote:
>
> Hi david
> It appears that there is a maximum of 512 font types in an excel workbook.
> Microsoft posted this
>
> http://support.microsoft.com/kb/215573
>
> The article indicates that the number often grows out of control due to auto-sizing ---
>
>
>
> I have found that if you google the error message you often come up with something useful.
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar