How do I resolve "too many different cell formats" error?

S

Seema

I have an old Excel file that has moved several Excel versions. Now, I am
unable to alter the formatting in any cell. I am getting the following error
message - "too many different cell formats".

I have tried removing all formatting, removing the formatting for one cell,
copying the spreadsheet and everything else I could think of but nothing
works.

Please help this is a very important financial spreadsheet.

Thanks
Seema
 
J

Jim Rech

There is no magic solution. You must 'simplify' the formatting.

http://support.microsoft.com/kb/213904

--
Jim
|I have an old Excel file that has moved several Excel versions. Now, I am
| unable to alter the formatting in any cell. I am getting the following
error
| message - "too many different cell formats".
|
| I have tried removing all formatting, removing the formatting for one
cell,
| copying the spreadsheet and everything else I could think of but nothing
| works.
|
| Please help this is a very important financial spreadsheet.
|
| Thanks
| Seema
 

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

Error Too Many Different Cell Formats (Different than others have 0
What does too many different cell formats mean? 2
Error Message : "Too may different cell formats" 1
A diolog box that says 'Too many different cell formats.' 1
Too Many Different Cell Format 3
Too many different cell formats 3
Linking data in MS Word into Excel 5
I get "too many formats" in Excel 2

Top