The information in this article applies to:
SYMPTOMS
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:
CAUSE
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.
WORKAROUND
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:
STATUSThis error only occurs in Microsoft Excel for Windows. Please comment this article if this behavior is seen to occur on other platforms. REFERENCES"User's Guide 1," pages 263-266 Additional query words: 4.00a 5.00c cool switch
Keywords : |
Last Reviewed: April 7, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |