Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limitations
No. You can read the help file for limitations.
-- Regards, Tom Ogilvy "Gary B" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limitations
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limitations
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limitations
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" wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limitations
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limitations
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" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel limitations
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel limitations | Excel Discussion (Misc queries) | |||
row limitations on excel | Excel Discussion (Misc queries) | |||
excel limitations | Excel Discussion (Misc queries) | |||
Excel Limitations?? | Excel Discussion (Misc queries) | |||
Excel Limitations | Excel Programming |