A client came to me with a weird issue: she was getting the message ‘Too many different cell formats’ from Excel. What’s up with that?
So, after searching around a little, I found this article from ExcelTips that explains the issue. I even followed the link in it to the Microsoft’s Support page to see if they have a solution. Well, the solution is… wait for it… reduce the number of formats! Oh well :/
On a side note, the Microsoft page claims the maximum number of formats is about 4000. The programmer in me believes that the actual number is 4096.
