Microsoft KB Archive/188442

= XL98: Lookup Wizard May Cause Errors =

Article ID: 188442

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



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.

