XL98: Lookup Wizard May Cause Errors

ID: Q188442

The information in this article applies to:

Microsoft Excel 98 Macintosh Edition

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.

Additional query words: XL98 hang hangs hanging hung lock up locks locking locked lockup freeze freezes freezing froze frozen stop stopping stopped won't respond waiting crash crashes crashing crashed quit quitting quits fail fails failing failed break

Keywords : kbdta xlwiz xlgpf
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug