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 different 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

Hi,

Take a look at

See

http://support.microsoft.com/default...b;en-us;213904


HTH

Unfortunately there is no direct way to count the number of unique cell
formats. In theory it's possible to devise code to do that but a lot of
work.

It is worth keeping an eye on the possibilities of excessive and unnecessary
formats, FWIW the 'too many formats' limit can be quite a lot less than the
quoted 4,000, on occasions.

Simple way is to pastespecial formats from a suitable cell over large areas
that will require similar. Delete empty unused rows and columns below and to
the right may help.

One way additional formats can creep in is after copying cells from other
workbooks. Use paste values where appropriate.

Regards,
Peter T


"emilija" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 different
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
>
>