Too many different cell format

M

Microsoft

Dear All

I have a quite big excel and i am trying to make some changes in format and
i receive the message "Too many different cell format"

Probably i have many different cell formats.
From where i can set up the format in order to know what must be the format
of the excel file?
I need away to identify the format from all sheets in order to give to the
all sheets as common format as i can.
Any ideas?
 
D

Dave Peterson

Some info:

XL: Error Message: Too Many Different Cell Formats
http://support.microsoft.com/default.aspx?scid=213904

I'd remove some of the formatting. (maybe format per column??)

If it gets too bad, you may not be able to reopen your workbook. If that
happens, then a few people have posted that they could open the file in
OpenOffice, then remove some of the formatting, save it and then excel would
open that file ok.

http://www.openoffice.org, a 60-65 meg download or a CD
 

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

Similar Threads

Too Many Different Cell Format 3
Too many different cell formats 1
Too many different cell formats 4
too many different cells format 3
Excel 2003; Lost Cell Shading 3
Too Many Different Cell Format error in Excel 2003 1
How to get rid of too many different format? 2
"Too many different call formats" error msg 1

Top