Excel limitations

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

No. You can read the help file for limitations.

--
Regards,
Tom Ogilvy

"Gary B" <GaryB@discussions.microsoft.com> wrote in message
news:587139C8-61C5-4CE3-BCF5-CD3096F5E30C@microsoft.com...
> 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

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

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

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






"Gary B" <GaryB@discussions.microsoft.com> wrote in message
news:887595E1-3925-4B25-B0AC-6C6F49FB04AE@microsoft.com...
> 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

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

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

"Gary B" <GaryB@discussions.microsoft.com> wrote in message
news:C2FB9025-0FD1-4E45-8287-B29BB9C76A17@microsoft.com...
>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

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.

"Tom Ogilvy" wrote:

> 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
>
>
>
>
>
>
> "Gary B" <GaryB@discussions.microsoft.com> wrote in message
> news:887595E1-3925-4B25-B0AC-6C6F49FB04AE@microsoft.com...
> > 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
>
>
>