Number of different cell formats

[emilija]

I have an excel file, which I can't opened because it has already too many
different cell formats, which I solved by formatting, but
is there a way how can I see a statistic of the number of formats used in
one file (out of 4000 I think), in order not to find my self in a same
situation in the future,
thanks in advance

 

[Pete_UK]

Excel must maintain a count somewhere in order to trigger this error,
but I don't think it is readily accessible.

The thing to do is to cut down on the number of different formats in
your workbook - don't go mad using lots of different type faces and
font sizes, borders and colours etc.

Hope this helps.

Pete