LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,549
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 Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
"Too Many Cell Formats" Error when opening a 2007 XLS file in 2003 James Excel Discussion (Misc queries) 0 November 3rd 09 02:14 AM
stop error message "too many different cell formats" Judy Excel Worksheet Functions 1 May 7th 09 05:31 PM
error message that says "too many different formats" Fix? JoJo Excel Worksheet Functions 1 March 25th 09 08:34 AM
Error Message : "Too may different cell formats" Rianto Excel Discussion (Misc queries) 1 March 13th 09 10:53 AM
How to override "Too Many Cell Formats" error comment. Delg New Users to Excel 3 August 8th 06 06:51 PM


All times are GMT +1. The time now is 10:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"