"Too many different cell formats"
Excel refuses one more colour or border. The workbook has hit the cell format limit, almost always because of duplicate formats piled up by copy and paste.
What the message says
An XLSX workbook can hold about 64,000 formatting combinations (font, border, fill, number format). Beyond that, Excel refuses any new format, and the file becomes slow and heavy long before.
Why it appears
- Copy and paste between workbooks: each paste brings its styles, which add up even when identical.
- Thousands of unused named styles ("Normal 2", "Normal 3"…), inherited from old files.
- Formatting applied cell by cell rather than to ranges.
Making it go away
- Delete unused styles: in the style gallery, one by one (thousands, sometimes).
- Merge identical formats: Excel does not do it by itself.
- Start again from a new workbook, pasting values only, at the cost of all formatting.
The tool that handles it
Reduce file size merges identical formats and removes those no cell uses, without changing the look of a single cell. The health check counts the formats beforehand, to see the margin.
Frequently asked questions
- How many formats can a workbook hold?
- About 64,000 combinations in an XLSX file. A healthy workbook rarely uses more than a few hundred.