microsoft excel all versions no more fonts error

[pablo007]

 

hello all has anyone come across and been able to resolve the issue where you get a no more fonts error when clicking into a cell in excel (I have no charts or graphs just lots of text)

 

Thanks in advance as always.

[6Foot2]

Link: You receive an error message when you add a chart to a workbook in Excel [Knowledge Base article]

 

This 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...

[pablo007]

I have no charts though mate ?

[6Foot2]

I have no charts though mate ?

I thought that if you had no other suggestions if you tried the suggested fixes anyway, maybe they would help?

[pablo007]

yeah I did with no joy, really appreciate the input though cheers Dave

[Bedders]

Copy it all into a new spreadsheet then try from there? (If you can copy it, that is).

 

Is it just this one spreadsheet or does it happen to all? If it's just this one spreadsheet, does it occur on different computers?

 

Have you tried restarting your computer (sorry for even suggesting this!) - it may be a caching issue.