Too Many Cell Format Error Comes up-Is there a solution

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sue - 30 Aug 2006 19:24 GMT

I have a large spreadsheet and I when I tried to Format a new cell I am
getting the error message Too Many Cell Formats and it won't let format any
more cells. Is there a work around for this?

Reply to this Message

Dave F - 30 Aug 2006 20:04 GMT

There's a built in limit to the amount of different formats that can be
applied in a spreadsheet.

The workaround would be to split the spreadsheet into two different
workbooks or to use Excel 2007 beta, which has significantly increased the
number of different cell formats that can be handled in a single workbook.

Dave

Signature

Brevity is the soul of wit.

> I have a large spreadsheet and I when I tried to Format a new cell I am
> getting the error message Too Many Cell Formats and it won't let format any
> more cells. Is there a work around for this?

Reply to this Message

Stephane Rodriguez - 31 Aug 2006 20:04 GMT

Yes, there is a solution.

http://office.microsoft.com/en-us/marketplace/EM101938821033.aspx

And directly here :

http://xlsgenreduction.arstdesign.com/

Signature

xlsgen - native Excel generator http://xlsgen.arstdesign.com
xlsgen RSS feed : http://www.arstdesign.com/BBS/rssxlsgen.php

> I have a large spreadsheet and I when I tried to Format a new cell I am
> getting the error message Too Many Cell Formats and it won't let format any
> more cells. Is there a work around for this?

Reply to this Message