Question on defining a name

A

Alex

If I select <Insert><Name><Define> I can define something
e.g (=0.95) as, say, discount rate.

Is there a limit to how many defintions you can make? For
example, I have made 13 definitions in the define dialog
box but cannot make anymore. They simply do not appear.
Am I to assume that 13 is the limit?

All help welcome.
 
C

Chip Pearson

Alex,

As far as I know, there is no limit on the number of names in a
workbook. I've done several projects with many thousands of names
each. I don't know why you are having the problems you describe.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

Doug Kanter

I don't know about the limit, but as far as the types of names, try and
think ahead and be sure they'll still make sense and be easy to understand
months or years from now. You'd be surprised at how today's logic can become
muddled later.
 
A

Alex

Chip Pearson

Thanks for the reply. Actually my Excel is now allowing
me to add more names. Must have been a temporary glitch.

Have a nice day.

Alex
 
Top