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.

See what this guy says:
http://www.quarrell.demon.co.uk/QAid/
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Prasanna" wrote in message
...
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.

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Anne Troy" wrote in message...
See what this guy says:
http://www.quarrell.demon.co.uk/QAid/
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Prasanna" wrote in message
...
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.