"Too many different cell formats" appears every time I try to for.

G

Guest

Evry time I attempt to format anything on my worksheet the notation "too many
cell formats appears and I can't change the format.
 
G

Guest

The link below only helps if you get the error message when you are trying to
format a cell. What do you do if the message appears when you are trying to
open the workbook? I can't get into the file to eliminate some cell formats
if I can't even get into the workbook.

Thanks in advance,
Tim
 
N

Nick Hodge

Tim

Tricky...If you are on a version pre XP try forwarding the workbook to
someone that has one of the later versions

That may work

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
G

Guest

Nick,

This worked!!! I didn't know of anyone with an Office version later than
2000, so I tried all kinds of other things, unsuccessfully. Finally, someone
in my IT department had Office 2003 and it opened the file and repaired it
automatically. Another Excel guru also recommended downloading Open Office,
a free program. Thanks.

Tim
 
N

Nick Hodge

Tim

Glad it worked out

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 

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 fomats' 2
How do you correct "too many different cell formats", message. 1
How can i get rid of the message "too many different cell formats" 1
Unwanted reformatting of protected cells 2
"Too many cell formats"? 2
Too Many Cell Formats Error 3
excel restarts on error "too many cell formats" 1
TOO MANY DIFFERENT CELL FORMATS 2

Top