no more new fonts in Linked excel graphs

J

jrluck

I have 2 workbooks.
The first workbook pulls data from an Access database.
The second work book is a summery workbook full of graphs. The graph
are pulled from the first workbook.
I have a number of links also in the second workbook that are linked t
the first workbook.
I am using Windows XP, Office XP.
The message I am getting i
.*_\"no_more_new_fonts_may_be_applied_in_this_workbook\"*_.
I need help in fixing this problem and understanding why this ha
happened
 
R

Raghu Prakash

Hi Jrluck,

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.


For More Information : Microsoft Knowledge Base Article - 215573

Please let know has this helped You...
Thank You...
Raghu...
 
Top