no more new fonts in Linked excel graphs

  • Thread starter Thread starter jrluck
  • Start date Start date
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top