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

[Anky]

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

 

[Nick Hodge]

Anky

Check here

http://support.microsoft.com/default.aspx?scid=kb;en-us;213904

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

 

[timlow]

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

 

[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)

 

[timlow]

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

 

[Nick Hodge]

Tim

Glad it worked out

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