No more new fonts can be applied Excel 2000

G

Guest

I have an excel containing some Chinese data. When I put data for around 200
rows, excel gives the following error "No more new fonts can be applied to
this workbook."
I dont have any charts in my workbook.
 
D

David McRitchie

Hi Prasanna,
Many people have managed to use Leo Heuser's macro and advice.
So if you want a free solution most of the regulars here have
managed to get past the first obstacle of opening the workbook.
See links
http://www.mvps.org/dmcritchie/excel/slowresp.htm#fonts

Difficulty in opening the workbook is not always a problem with this problem.
I know that it was for me, but being a long time ago we've forgotten how
to specifically tell others how -- so you will have to experiment a bit.
To get the workbook open, you might try:
-- workbook as the only application running
-- starting Excel in Safe Mode
-- Opening in a different version of Excel, or even just a different
machine (different fonts).
-- Opening in Open Office (openoffice.org see my backup.htm page)

After the workbook is open you can remove usage of some fonts, and
use Leo's macro. You might split the workbook into two until you've
resolved the problem, watch out for dependencies and make backups.

Actually your problem is less serious than the "too many formats" message,
so I don't think you have a problem opening the workbook.
 

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

Top