too many different cell formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Valley Boy - 30 Sep 2005 14:46 GMT

What does the error message 'too many different cell formats' mean in excel?
I cannot open a spreadsheet that was sent to me by a Java interface from an
iSeries.

Reply to this Message

Simon Murphy - 30 Sep 2005 20:24 GMT

Common problem on larger workbooks
You have too many combinations of font, colour & borders etc

Heres a tool to fix it:
http://www.quarrell.demon.co.uk/QAid/

heres the MSDN article with solutions (basically reduce the number of format
combinations you have)

http://support.microsoft.com/kb/213904

cheers
Simon

> What does the error message 'too many different cell formats' mean in
> excel?
> I cannot open a spreadsheet that was sent to me by a Java interface from
> an
> iSeries.

Reply to this Message