PC Review


Reply
Thread Tools Rate Thread

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

 
 
Seema
Guest
Posts: n/a
 
      18th Jun 2008
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
 
Reply With Quote
 
 
 
 
Jim Rech
Guest
Posts: n/a
 
      18th Jun 2008
There is no magic solution. You must 'simplify' the formatting.

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

--
Jim
"Seema" <(E-Mail Removed)> wrote in message
news:6188EF96-8EB4-4906-AAEB-(E-Mail Removed)...
|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


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 James Microsoft Excel Misc 0 3rd Nov 2009 02:14 AM
any solution to the "too many cell formats error" in excel? =?Utf-8?B?TWluaQ==?= Microsoft Excel Misc 1 31st May 2006 11:45 AM
File won't open. Error message "too many different cell formats" =?Utf-8?B?YmF5dHVsc2E=?= Microsoft Excel Worksheet Functions 1 12th Sep 2005 07:21 PM
cannot load excel file - "too many different cell formats" error s =?Utf-8?B?UmljaGFyZCBCYWlsZXk=?= Microsoft Excel Misc 3 15th May 2005 12:33 PM
How do I eliminate, in Excel XP, "too many cell formats" error? =?Utf-8?B?Um9qb0xvYm8=?= Microsoft Excel Crashes 1 23rd Mar 2005 07:04 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:35 PM.