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.

As per Excel Help: Names in a workbook - limited by available memory

--
Biff
Microsoft Excel MVP


wrote in message
ups.com...
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

" wrote:

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.

Thanks.