Hi,

I have created an excel that holds about 700kb data. This includes
macros to import data from other excel sheet retaining the format of
the import sheet to be imported.
I sometimes receive this error 'Too many different cell format' after
which this workbook loses all its format completely. This is also not
recoverable. Could some one help me with this problem.

Thanks,
Gayathri.

Hi Gayathri

Try this

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default...b;en-us;213904

David McRitchie posted this

Leo Heuser posted a macro 2001-05-06 in programming as a very major revision of the macro in the eee007 article.
http://groups.google.com/groups?selm...%40tkmsftngp02



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Gayathri S" wrote in message om...
Hi,

I have created an excel that holds about 700kb data. This includes
macros to import data from other excel sheet retaining the format of
the import sheet to be imported.
I sometimes receive this error 'Too many different cell format' after
which this workbook loses all its format completely. This is also not
recoverable. Could some one help me with this problem.

Thanks,
Gayathri.