I have looked in Help section, and while it shows what the limitations are,
it DOES NOT show me how many interations have actually been used , nor how
many colours have actually been used. I can see, for example that I can use
56 colours, but how can I count how many colours have actually been used. I
can also see that I can have 4,000 cell styles, but again, how do I count how
many I have used ......and so on.

"FSt1" wrote:

hi,
in excel help, type the word "specifications". this is probably what you are
looking for.

regards
FSt1

"Gary B" wrote:

Hi Tom,

I wasnt actually seeking to find out what the limitations are, but rather is
the workbook approaching or exceeding these limitations.
ie how many formulas are in use, how many formats are used in the workbook,
how many fonts are used in the workbook and so on

"Gary B" wrote:

I am aware that Excel has some built in limitations 32,000 iterations etc.

Is there some code I can run over a workbook that will report on each of
these limitations (all internal limitations)? Ie formulas, colours used,
formats and fonts used etc ?

Thanks in advance.

Gary