'Too Many Different Cell Formats' - Error Message

Ken T. · External Since: Sep 19, 2009 Posts: 1

I get this message when just trying to bold a number in my Forecast Model at
work. Have anybody seen this before? If so, how did you resolve it.

I am currently using Excel 2003 and the file is only 7.1MB.
Can you help me?
Thanks.

Stephane Rodriguez · External Since: Sep 21, 2009 Posts: 1

http://xlsgenreduction.arstdesign.com

"Ken T." <Ken T..DeleteThis@discussions.microsoft.com> a écrit dans le message de news:
90C4D065-CE80-4DEE-9AA8-E1110830DB74.DeleteThis@microsoft.com...
>I get this message when just trying to bold a number in my Forecast Model
>at
> work. Have anybody seen this before? If so, how did you resolve it.
>
> I am currently using Excel 2003 and the file is only 7.1MB.
> Can you help me?
> Thanks.

FSt1 · External Since: Mar 03, 2006 Posts: 407

hi
xl2003 allows only 4,000 different combinations of cell formats. xl2007 has
uped this to 64000 (presumably due to the larger sheets). since this is a
ceiling, there is no real fix except don't exceed the limit. see this site
for more details and possible fixes.
http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

regards
FSt1

"Ken T." wrote:

> I get this message when just trying to bold a number in my Forecast Model at
> work. Have anybody seen this before? If so, how did you resolve it.
>
> I am currently using Excel 2003 and the file is only 7.1MB.
> Can you help me?
> Thanks.