Prev: How do I make the drop down list view larger?
Next: Formula ?
From: C.T. on 3 Jun 2010 12:47
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 <karm...(a)discussions.microsoft.com> 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/blog/cns!53E1D37F76F69444!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.
> .
>
From: Jim Cone on 3 Jun 2010 13:13

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." <CT(a)discussions.microsoft.com>
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 <karm...(a)discussions.microsoft.com> 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/blog/cns!53E1D37F76F69444!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.

 | 
Pages: 1
Prev: How do I make the drop down list view larger?
Next: Formula ?