XL98: Lookup Wizard May Cause Errors (188442)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q188442 SYMPTOMS
In Microsoft Excel 98 Macintosh Edition, when using the Lookup Wizard you
may experience one of the following symptoms:
The Template Wizard dialog box stops responding and you have to quit Excel.
-or-
You receive the following error message, and you have to quit Excel:
"Run-time error '9'
Subscript out of range".
-or-
You receive the following error message, and Excel quits unexpectedly:
The application "Microsoft Excel" has unexpectedly quit, because an
error of type 2 occured.
You should save your work in other open applications and restart the
computer
CAUSE
These problems may occur when the Template Wizard dialog box is visible,
and you attempt to use the Lookup Wizard.
WORKAROUND
To work around this problem, do not use the Lookup Wizard when the Template
Wizard dialog box is visible.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98
Macintosh Edition.
MORE INFORMATION
In Microsoft Excel 98 Macintosh Edition, when the Template Wizard dialog
box is displayed, the Lookup Wizard as well as other menu items and command
bars are available.
REFERENCES
For more information about the Template Wizard, click Contents And Index
on the Help menu (or on the Balloon Help menu if you are using a version of
the Macintosh operating system earlier than 8.0), click the Index button in
MS Excel Help, type the following text
Template Wizard with Data Tracking
and then click Show Topics. Select the "What is the Template Wizard with
Data Tracking?" topic, and click Go To. If you are unable to find the
information you need, ask the Office Assistant.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbbug KB188442 |
|---|
|