Question on defining a name

  • Thread starter Thread starter Alex
  • Start date Start date
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.
 
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
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Questions on Define Names 3
Wierd names defined as arrays of constants?!? 1
Define name 6
insert>name>define 7
A "ghost" defined name 1
Name Define 6
Formula via Define Name (not working) 3
Invalid References in formula 3

Back
Top