Limit To Number Of Named Formulas?

  • Thread starter Thread starter cqdigital
  • Start date Start date
C

cqdigital

Is there a limit to the number of named formulas that Excel can store
under Insert/Name/Define on the menu bar? I've been asked to do a heap
of scrolling charts and I'll need to store several hundred formulas.

Any help is appreciated.
 
Hi,

Named variables are User defined function. There is no limit to number of
named definition. It is restricted based on the available memory. Named
variable are global variable. They can be used in all the Worksheet of a
Workbook.

Challa Prabhu
 
Back
Top