XL2001: Conditional Sum Wizard Returns an Error When Visual Basic for Applications Is Not Installed (272889)

The information in this article applies to:

This article was previously published under Q272889

SYMPTOMS

When you attempt to use the Conditional Sum Wizard in Microsoft Excel 2001, you may receive the following error message:

The Conditional Sum Wizard encountered an unexpected error. Please try again.

This behavior occurs if Microsoft Visual Basic for Applications is not installed on the computer.

To resolve this issue, install Microsoft Visual Basic for Applications on the computer. To do so, follow these steps:

Start Microsoft Office Installer on the Microsoft Office 2001 compact disc.
Select Custom Install.
Under Office Tools, click to select Visual Basic for Applications, and then click Install.
After Office 2001 has been successfully re-installed, click Quit to quit the Installer.

Microsoft has confirmed that this is a problem in Microsoft Excel 2001 for Mac.

For more information about using the Conditional Sum Wizard in an Excel workbook, follow these steps:

On the Help menu, click Contents and Index, click Index, and then click C.
Scroll down until you locate condition, and then click the arrow to the left to view a list of topics under the general topic.
Click Summarize values that meet conditions by using the Conditional Sum Wizard.

If you cannot find the information that you want, ask the Office Assistant.

Modification Type:	Major	Last Reviewed:	9/11/2002
Keywords:	kbbug KB272889