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.
