Reference Name - Limit?
 

Is there a limit to the number of defined named references within a single
workbook?
--
Appreciate your help!

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

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!

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