Microsoft Excel Maximum number of fonts exceeded

Asked By halleleilani2 30 points N/A Posted on - 05/05/2012

Hello Everyone,

The error message “Maximum number of fonts exceeded” appears whenever I am trying to open the generated Excel file in Excel 2007. I have generated reports from jasper report and then export it to excel format. Can somebody guide me to the reasons for that error message and how to fix it?

Thank you in Advance.

• Status: Open
• Question Views: 3487
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Norwood-Koonce 0 points N/A #195703

Microsoft Excel Maximum number of fonts exceeded

MS Excel has a limitation on the number of formats allowed (It depends on the version). So if you can clean up the formats and reduced the number of various fonts used in the document you should be able to avoid that message.

And also if you have a lot of charts in the workbook, make sure they do not have their fonts set to auto scale as that can cause this problem. Custom styles are another thing that is delivering that message to you. So keep your document with less number of formatting styles and less numbers of fonts.

About Norwood-Koonce

Questions
0

Answers
96

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 05/05/2012
• Question Category: MS Excel