Excel: "Not Enough Memory" Error When Defining NamesID: Q104696
|
If you define a large number of names (over 6,000) on a worksheet or
macro sheet, you may receive one of the following errors when you
choose Define Name from the Formula menu:
This error occurs because of a limitation in the Standard Dialog
Manager (SDM), which manages memory allocation for dialog boxes in
Microsoft Excel. If the number of names on your worksheet is too
great, the SDM runs out of memory when it tries to populate the "Names
in Sheet" list box.
The number of defined names that you can have before the error begins
to occur varies, but is usually between 6300 and 6800 names, depending
on the complexity of the names that you have defined.
Note that the DEFINE.NAME() and DELETE.NAME() macro commands are not
influenced by the amount of available memory in the SDM.
To avoid this problem, delete enough names so that the SDM can handle
the remaining names. Because the Define Name dialog box is
unavailable, you can delete names in two ways:
This error only occurs in Microsoft Excel for Windows. Please comment this article if this behavior is seen to occur on other platforms.
"User's Guide 1," pages 263-266
Additional query words: 4.00a 5.00c cool switch
Keywords :
Version : 4.00 4.00a 5.00 5.00c
Platform : WINDOWS
Issue type :
Last Reviewed: April 7, 1999