Excel Tips Monster

Too many formats

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.