Number of different cell formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emilija - 29 Jan 2008 16:04 GMT

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

Reply to this Message

Pete_UK - 29 Jan 2008 17:49 GMT

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

> 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

Reply to this Message