| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Maximum number of named ranges?
Does anyone know the maximum number of named ranges allowed in xl03 and xl07?
Thanks! -- JNW |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
More than you could ever reasonably hope to manage... That is more of an
editorial than an answer but I can not think of a circumstance where I would run into the limit. What are you up to that you want to know the limit??? -- HTH... Jim Thomlinson "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
~500 right now, but could envision hitting upwards of 5k. I figure I'm more
than safe in 07 since they've all but done away with most memory limitations. I'm more worried about xl03. Along the same lines, any known speed issues with named ranges? Is is faster/slower? (code and worksheet references) -- JNW "Jim Thomlinson" wrote: More than you could ever reasonably hope to manage... That is more of an editorial than an answer but I can not think of a circumstance where I would run into the limit. What are you up to that you want to know the limit??? -- HTH... Jim Thomlinson "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
Names in a workbook Limited by available memory
http://office.microsoft.com/en-us/as...992911033.aspx -- Gary "JNW" wrote in message ... Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
I too would like to see some discussion concerning speed comparisons
between using named ranges and specified cell ranges. I use a lot of named ranges in all the Excel applications I develop to make things easier to debug visually and to make a bit of "human sense" of it all. Dennis |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
Since named ranges involve Excel doing more work they are slower than direct
references. I have used workbooks with more than 50K names (xl97-xl07), but I would not recommend it. Personally I would feel comfortable with up to 5K names and with that kind of volume you probably wont hit any speed problem unless they are all dynamic ranges or other named formulae. Presumably you are using our Name Manager ... http://www.decisionmodels.com/downloads.htm Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm "JNW" wrote in message ... ~500 right now, but could envision hitting upwards of 5k. I figure I'm more than safe in 07 since they've all but done away with most memory limitations. I'm more worried about xl03. Along the same lines, any known speed issues with named ranges? Is is faster/slower? (code and worksheet references) -- JNW "Jim Thomlinson" wrote: More than you could ever reasonably hope to manage... That is more of an editorial than an answer but I can not think of a circumstance where I would run into the limit. What are you up to that you want to know the limit??? -- HTH... Jim Thomlinson "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
Thanks Charles
I haven't used NameManager yet, but I think I'll start. Looks useful. I'm using the named ranges for range that I have to refer to in the code. The client loves to add columns and rows and generally mess with the format. Using the names helps me not have to update the code everytime they want a structure change. Any other methods out there that I have overlooked? Thanks again. -- JNW "Charles Williams" wrote: Since named ranges involve Excel doing more work they are slower than direct references. I have used workbooks with more than 50K names (xl97-xl07), but I would not recommend it. Personally I would feel comfortable with up to 5K names and with that kind of volume you probably wont hit any speed problem unless they are all dynamic ranges or other named formulae. Presumably you are using our Name Manager ... http://www.decisionmodels.com/downloads.htm Charles __________________________________________________ Outlines for my Sessions at the Australia Excel Users Group http://www.decisionmodels.com/OZEUC.htm "JNW" wrote in message ... ~500 right now, but could envision hitting upwards of 5k. I figure I'm more than safe in 07 since they've all but done away with most memory limitations. I'm more worried about xl03. Along the same lines, any known speed issues with named ranges? Is is faster/slower? (code and worksheet references) -- JNW "Jim Thomlinson" wrote: More than you could ever reasonably hope to manage... That is more of an editorial than an answer but I can not think of a circumstance where I would run into the limit. What are you up to that you want to know the limit??? -- HTH... Jim Thomlinson "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
I'm hitting a limit as well. See the posting: Limit (not memory) consumed
by Range Names, UDF calls, VB code, st "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
http://office.microsoft.com/en-us/ex...992911033.aspx -- Gary "Dean Meyer" wrote in message ... I'm hitting a limit as well. See the posting: Limit (not memory) consumed by Range Names, UDF calls, VB code, st "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
The maximum Named range in a workbook is limited by available memory.
Please Refer: http://office.microsoft.com/en-us/ex...992911033.aspx I hope this helps. Selva V Pasupathy For more on Excel, VBA, and other resources Please visit: http://socko.wordpress.com |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
Just out of curiosity, how many names do you have?
Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 17 Dec 2008 07:57:12 -0800, Dean Meyer wrote: I'm hitting a limit as well. See the posting: Limit (not memory) consumed by Range Names, UDF calls, VB code, st "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
I don't know what the limit actually is, but I have seen useable workbooks
with over 50000 Defined Names (personally I would not recommend using this many ...) There used to be a limit on the depth of recursion allowed (names referring to names referring to names ...), not sure if this has been extended in Excel 2007. Charles ___________________________________ London Excel Users Conference April 1-2 The Excel Calculation Site http://www.decisionmodels.com "Dean Meyer" wrote in message ... I'm hitting a limit as well. See the posting: Limit (not memory) consumed by Range Names, UDF calls, VB code, st "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
I did check a while ago following protestations from someone in this ng and
for me there was absolute limit of 64k names (ie 65,536). I don't quite recall if that was how many could be saved rather than created, either way that was the limit. Regards, Peter T "Charles Williams" wrote in message ... I don't know what the limit actually is, but I have seen useable workbooks with over 50000 Defined Names (personally I would not recommend using this many ...) There used to be a limit on the depth of recursion allowed (names referring to names referring to names ...), not sure if this has been extended in Excel 2007. Charles ___________________________________ London Excel Users Conference April 1-2 The Excel Calculation Site http://www.decisionmodels.com "Dean Meyer" wrote in message ... I'm hitting a limit as well. See the posting: Limit (not memory) consumed by Range Names, UDF calls, VB code, st "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#14
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
Hi Peter,
Sounds reasonable to me, I will have to to try to break the 64K barrier! Charles ___________________________________ London Excel Users Conference April 1-2 The Excel Calculation Site http://www.decisionmodels.com "Peter T" <peter_t@discussions wrote in message ... I did check a while ago following protestations from someone in this ng and for me there was absolute limit of 64k names (ie 65,536). I don't quite recall if that was how many could be saved rather than created, either way that was the limit. Regards, Peter T "Charles Williams" wrote in message ... I don't know what the limit actually is, but I have seen useable workbooks with over 50000 Defined Names (personally I would not recommend using this many ...) There used to be a limit on the depth of recursion allowed (names referring to names referring to names ...), not sure if this has been extended in Excel 2007. Charles ___________________________________ London Excel Users Conference April 1-2 The Excel Calculation Site http://www.decisionmodels.com "Dean Meyer" wrote in message ... I'm hitting a limit as well. See the posting: Limit (not memory) consumed by Range Names, UDF calls, VB code, st "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
|
#15
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Maximum number of named ranges?
Hi Charles,
Great, barriers are there to be broken <g Might take a while to make 64k+ names. Regards, Peter T "Charles Williams" wrote in message ... Hi Peter, Sounds reasonable to me, I will have to to try to break the 64K barrier! Charles ___________________________________ London Excel Users Conference April 1-2 The Excel Calculation Site http://www.decisionmodels.com "Peter T" <peter_t@discussions wrote in message ... I did check a while ago following protestations from someone in this ng and for me there was absolute limit of 64k names (ie 65,536). I don't quite recall if that was how many could be saved rather than created, either way that was the limit. Regards, Peter T "Charles Williams" wrote in message ... I don't know what the limit actually is, but I have seen useable workbooks with over 50000 Defined Names (personally I would not recommend using this many ...) There used to be a limit on the depth of recursion allowed (names referring to names referring to names ...), not sure if this has been extended in Excel 2007. Charles ___________________________________ London Excel Users Conference April 1-2 The Excel Calculation Site http://www.decisionmodels.com "Dean Meyer" wrote in message ... I'm hitting a limit as well. See the posting: Limit (not memory) consumed by Range Names, UDF calls, VB code, st "JNW" wrote: Does anyone know the maximum number of named ranges allowed in xl03 and xl07? Thanks! -- JNW |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rapidly Create a Large Number of Named Ranges | Excel Worksheet Functions | |||
| Named ranges scope / workbook/worksheet level named ranges- changeswith variable use... | Excel Programming | |||
| Limit to number of named ranges before Excel starts messing things up? | Excel Worksheet Functions | |||
| Max number of named ranges | Excel Worksheet Functions | |||
| Maximum number of Name ranges | Excel Programming | |||
Linear Mode
