Andism.com's Blog

Excel No more new fonts may be applied in this workbook

Posted in Computer Support by andismcom on September 23, 2009

his problem occurs because of the Auto scale setting. When you add a chart to the workbook, the Auto scale setting is enabled by default. This setting causes charts to use two or more fonts instead of one. When you add multiple charts to a workbook with this setting enabled, the font limitation for a workbook may be reached. For Microsoft Excel 2000 and later, the maximum number of fonts is 512. If you add charts manually or if you copy and paste existing charts, you can reach the font limitation for a workbook. The following is an example of copying existing charts:

* You create a chart object in the worksheet.
* You copy and paste the chart object on the same worksheet ten or more times.
* You then copy the worksheet several times in the same workbook.

OTE: Because there are several versions of Microsoft Windows, the following steps may be different on your computer. If they are, see your product documentation to complete these steps.

1. Quit all running programs.
2. Click the Start button, and then click Run.
3. In the Open box, type regedit , and then click OK.
4. Go to the following registry subkey (folder), depending on your version of Excel:
Excel 2003
HKEY_CURRENT_USERSoftwareMicrosoftOffice11.0ExcelOptions
Excel 2002
HKEY_CURRENT_USERSoftwareMicrosoftOffice10.0ExcelOptions
Excel 2000
HKEY_CURRENT_USERSoftwareMicrosoftOffice9.0ExcelOptions
5. Point to New on the Edit menu, and then click DWORD Value. Type AutoChartFontScaling , and then press ENTER.
6. Click Modify on the Edit menu. Type 0 in the Value Data box, and then click OK.
7. Click Exit on the File menu to quit the Registry Editor.

After adding this registry key, all new charts created in Excel will not have the Auto scale setting selected.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: