My boss has created a rather large workbook in Lotus 1-2-3 with 10 or so worksheets. I am converting the company to MS Office, so he loaded his workbooks into Excel. He now gets an error that says “Too many different cell formats” and won’t let him change anything. He has put in a very wide array of colors, font types, font sizes, borders etc. It’s basicly used as a charting and forcasting tool for the business. The fonts and colors allow him to quickly identify the data that he wants to see.
Checking MS web site, the is one document. It says:
This problem occurs when the workbook contains more than approximately 4,000 different combinations of cell formats. A combination is defined as a unique set of formatting elements that are applied to a cell. A combination includes all font formatting (for example: typeface, font size, italic, bold, and underline), borders (for example: location, weight, and color), cell patterns, number formatting, alignment, and cell protection.
So, I told him to simply his worksheet. Because of the complexity, neither one of knows how to identify where all the formating is taking place.
Does anyone, Excell expert have any ideas about what to do?