How do you correct "too many different cell formats", message.

P

PIDEE

I continue to receive a message that there are too many different cell
formats in the spreedsheet. How do I change this? How many formats are
acceptable? Using Microsoft Office 2003.
 
E

Elkar

Excel does have limits on how many different formats can exist in a single
workbook. For example, in Excel 2003 you are limited to 56 different colors,
4000 cell styles, and 200-250 number formats. You can see a full list of
Excel's limitations by searching for "specifications" in Help.

Almost all of these limitations are vastly increased in Excel 2007. Such
as, 16 million colors, and 64000 cell styles, however number formats are
still limited to 200-250.

So, in answer to your question, your best option would be to reduce the
number of different formats you are using. But, upgrading to 2007 may help
as well.

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top