Reference Name - Limit?

L

LorrieM

Is there a limit to the number of defined named references within a single
workbook?
 
D

Dave Peterson

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.
 
S

Sheeloo

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"
 
L

LorrieM

Thanks Sheelo and Dave
--
Appreciate your help!


Dave Peterson said:
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.
 
Top