ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Too many cell formats error (https://www.excelbanter.com/excel-programming/426914-too-many-cell-formats-error.html)

edward

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

FSt1

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



All times are GMT +1. The time now is 07:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com