XL97: Error Running Wizard When a Control Is Active (169105)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q169105 SYMPTOMS
In Microsoft Excel 97, when you click a menu item that starts a wizard or a function built into an add-in, you may receive one of the following error messages:
Template Wizard
Run-time error '1004':
RemoveAllItems method of DropDown class failed
Solver
Solver: An unexpected internal error occurred, or available memory
was exhausted.
Save as HTML, Conditional Sum, or Lookup
Run-time error '1004':
Unable to get the CurrentRegion property of the Range class
CAUSE
These problems occur if a control is active in the worksheet when you click
a menu item that starts any of the wizards or functions listed in this
article.
WORKAROUND
To prevent these problems from occurring, select a cell or a range in the
worksheet before you click a menu item that starts any of the wizards or
functions listed in this article.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
Certain wizards and functions that require that a cell or a range of cells
be selected do not work correctly if a control, such as a command button,
an option button, a check box, or a list box, is active in the worksheet
when you use them.
Wizards and functions not listed in this article do not require that a cell
or a range of cells be selected. Therefore, the problems described in this
article do not occur when you use those wizards or functions. For example,
the File Conversion Wizard and the Web Form Wizard work correctly even when
a control is active.
| Modification Type: | Major | Last Reviewed: | 10/22/2000 |
|---|
| Keywords: | kberrmsg kbprb KB169105 |
|---|
|