A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Error message: "Too many cell formats"



 
 
Thread Tools Display Modes
  #1  
Old February 22nd, 2010, 10:41 PM posted to microsoft.public.excel.misc
karmine
external usenet poster
 
Posts: 1
Default Error message: "Too many cell formats"

How do you correct this ?
  #2  
Old February 22nd, 2010, 10:55 PM posted to microsoft.public.excel.misc
Bob I
external usenet poster
 
Posts: 10,698
Default Error message: "Too many cell formats"

You receive a "Too many different cell formats" error message in Excel
http://support.microsoft.com/kb/213904

karmine wrote:

How do you correct this ?


  #3  
Old March 13th, 2010, 07:37 AM posted to microsoft.public.excel.misc
XLGeek
external usenet poster
 
Posts: 1
Default Error message: "Too many cell formats"

On Feb 22, 1:41*pm, karmine wrote:
How do you correct this ?


Lots of people seem to run into this problem. Most often the issue is
related to the excessive number of unused and often corrupted styles
and not so much the total count of the cell unique cell format combos.
I wrote a utility to fix XL2007 OOXML files that can be saved down to
XL2003. Here is the link to the blog post:
http://sergeig888.spaces.live.com/bl...9444!534.entry

Requres .Net3.5 and MS Excel 2007. Will fix xlsx or xlsm files.

No need to run the risk of further corrupting your file by using Open
Office like it is suggested on some other forums.
  #4  
Old June 3rd, 2010, 05:47 PM posted to microsoft.public.excel.misc
C.T.[_2_]
external usenet poster
 
Posts: 3
Default Error message: "Too many cell formats"

Some clarification and guidance, please.
I am using Excel 2003. My workbooks are popping up the 'too many cell
format' error messages. Will your application work on Excel 2003? If not, do
have any suggestions?

Thanks!

"XLGeek" wrote:

On Feb 22, 1:41 pm, karmine wrote:
How do you correct this ?


Lots of people seem to run into this problem. Most often the issue is
related to the excessive number of unused and often corrupted styles
and not so much the total count of the cell unique cell format combos.
I wrote a utility to fix XL2007 OOXML files that can be saved down to
XL2003. Here is the link to the blog post:
http://sergeig888.spaces.live.com/bl...9444!534.entry

Requres .Net3.5 and MS Excel 2007. Will fix xlsx or xlsm files.

No need to run the risk of further corrupting your file by using Open
Office like it is suggested on some other forums.
.

  #5  
Old June 3rd, 2010, 06:13 PM posted to microsoft.public.excel.misc
Jim Cone[_2_]
external usenet poster
 
Posts: 434
Default Error message: "Too many cell formats"


Did you read the information posted by Bob I ?
http://support.microsoft.com/kb/213904

I wrote an Excel add-in (Formats & Styles) to remove unused cell styles.
It works on xl97 thru xl2007.
It will only help you if you have an excessive amount of styles created in your workbook(s).
Download from...
http://excelusergroup.org/media/p/4861.aspx
-or-
http://www.mediafire.com/PrimitiveSoftware

--
Jim Cone
Portland, Oregon USA





"C.T."
wrote in message
Some clarification and guidance, please.
I am using Excel 2003. My workbooks are popping up the 'too many cell
format' error messages. Will your application work on Excel 2003? If not, do
have any suggestions?
Thanks!




"XLGeek" wrote:
On Feb 22, 1:41 pm, karmine wrote:
How do you correct this ?

Lots of people seem to run into this problem. Most often the issue is
related to the excessive number of unused and often corrupted styles
and not so much the total count of the cell unique cell format combos.
I wrote a utility to fix XL2007 OOXML files that can be saved down to
XL2003. Here is the link to the blog post:
http://sergeig888.spaces.live.com/bl...9444!534.entry
Requres .Net3.5 and MS Excel 2007. Will fix xlsx or xlsm files.
No need to run the risk of further corrupting your file by using Open
Office like it is suggested on some other forums.


 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:13 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.