| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Reference Name - Limit?
Is there a limit to the number of defined named references within a single
workbook? -- Appreciate your help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Name - Limit?
If you search xl's help for "Excel specifications and limits", you'll see this:
Names in a workbook Limited by available memory I don't know how many you're using, but if you think you may be approaching a limit set by excel, there may be other ways of doing what you want to do. LorrieM wrote: Is there a limit to the number of defined named references within a single workbook? -- Appreciate your help! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Name - Limit?
Thanks Sheelo and Dave
-- Appreciate your help! "Dave Peterson" wrote: If you search xl's help for "Excel specifications and limits", you'll see this: Names in a workbook Limited by available memory I don't know how many you're using, but if you think you may be approaching a limit set by excel, there may be other ways of doing what you want to do. LorrieM wrote: Is there a limit to the number of defined named references within a single workbook? -- Appreciate your help! -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Reference Name - Limit?
No, not in 2003 or later...
Look under "" in Excel help for limits specific to your version This is what HELP says - "Limited by available memory" "LorrieM" wrote: Is there a limit to the number of defined named references within a single workbook? -- Appreciate your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Limit decimal places in a string cell reference | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| limit characters returned a cell reference | Excel Worksheet Functions | |||
| Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) | |||
Hybrid Mode
