Software

Ask something
Discussion Locked

MS EXCEL (Office XP)

0 helpful
3 replies

by karansoin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In a work book i have five worksheets containing data and in each worksheet there are nine charts.
Also there is another worksheet that has data that is linked from the first five worksheets. While making the charts in the worksheets an error is generated " NO NEW FONTS CAN BE ADDED IN THIS WORKBOOK" while changing the titles using the chart options.Als the wokbook closes and auto saves and generates recovered files.
Also thre is a message that excel has encountered a problem. Asking for permission to send error report or not.
Never come across this error before. The file size is a mere 522 KB.
Worked with bigger files containing more no of charts .
Please suggest what I do in this case

3 replies

by sgt_shultz

i just love microsoft. no sarcasm. they have these weird bugs. but they tell you about them. look what i found at support.microsoft.com, Excel, "no new fonts" exact phrase...
XL2000: Error Copying Worksheets Containing Charts
View products that this article applies to.
This article was previously published under Q215573
SYMPTOMS
When you copy a worksheet with embedded chart objects several times, you may receive the following error message:

No more new fonts may be applied in this workbook.
When you click OK to clear the error message, you may receive the following error message:

Cell table Integrity failure.
CAUSE
This problem may occur if all of the following are true:
You created a chart object in the worksheet.

-and-

The chart object contains a title.

-and-

You pasted a chart object on the same worksheet ten or more times.

-and-

You copied the worksheet several times in the same workbook.

WORKAROUND
To workaround this behavior, use either of the following methods.
Method 1: Disable Autoscaling in the Chart
Select the chart.
On the Format menu, click Selected Chart Area.
Click the Font tab.
Click to clear the Autoscale check box.
Click OK.
Method 2: Split the Number of Charts into Multiple Workbooks
You can cut some of your charts in your workbook and paste them into one or more new workbooks to decrease the amount of resources that each workbook needs.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

by karansoin

This was gr8!
I had to rebuild the charts again though as the error did not allow to deselect auto scaling.
Thanks

This discussion is closed to new replies.