Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 87
Default Too many cell formats error

Hi everybody
Is there a way to programatically solve this error?
--
Best regards,
Edward
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,942
Default Too many cell formats error

hi
afraid not. in 2003 and back, you are limited to 4000 different format
combinations. exceed that and you start getting the too many formats error.
they upped the number in 2007 because of the larger sheets but not sure by
how much.
see this site for further explaition and possible fixes
http://support.microsoft.com/default...b;en-us;213904

regards
FSt1

"Edward" wrote:

Hi everybody
Is there a way to programatically solve this error?
--
Best regards,
Edward

Reply
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
Error Too Many Different Cell Formats (Different than others have JD Wood Excel Discussion (Misc queries) 0 September 29th 09 05:34 PM
too many different cell formats error penni Excel Discussion (Misc queries) 2 August 14th 08 11:38 PM
ERROR: Too many cell formats ChrisA Excel Discussion (Misc queries) 1 May 25th 05 07:41 PM
Formats: Too many different cell formats error message [email protected] Excel Programming 3 February 1st 05 01:34 AM
Error: Too many cell formats AgLem Excel Programming 2 February 17th 04 09:21 AM


All times are GMT +1. The time now is 09:44 AM.

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

About Us

"It's about Microsoft Excel"