Excel limitations

[Guest]

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

 

[Tom Ogilvy]

No. You can read the help file for limitations.

 

[Guest]

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

 

[Guest]

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

regards
FSt1

 

[Tom Ogilvy]

No, unless it is a setting, there is no property you can query for most of
this.

You can only use 56 colors for cells, so I don't think you need to worry
about that.

No for formats
no for formulas although you can use usedrange.SpecialCells(xlformulas), but
I there isn't a limit on formulas.
No for fonts
You can probably get iterations, but can't set it above the limit

So I think the general answer is no.

--
Regards,
Tom Ogilvy

 

[Guest]

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.

 

[Robin Hammond]

Gary,

The StyleMapper add-in on my site will give you an enumeration of all styles
in use, and the facility to remap them.

Robin Hammond
www.enhanceddatasystems.com

 

[Guest]

Thanks all..... I thought I would be able to have some code that would loop
through each cell and establish each cells attributes, and while I can do
this for some things, such as does it have a colour, and what its font is
etc, I was hoping there would be some code someone had written that would
capture everything, so i didnt have to reinvent the wheel so to speak.