Microsoft KB Archive/272889

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

Article ID: 272889

Article Last Modified on 1/29/2007

-

APPLIES TO


 * Microsoft Excel 2001 for Mac

-



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.



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



RESOLUTION
To resolve this issue, install Microsoft Visual Basic for Applications on the computer. To do so, follow these steps:
 * 1) Start Microsoft Office Installer on the Microsoft Office 2001 compact disc.
 * 2) Select Custom Install.
 * 3) Under Office Tools, click to select Visual Basic for Applications, and then click Install.
 * 4) After Office 2001 has been successfully re-installed, click Quit to quit the Installer.



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



MORE INFORMATION
For more information about using the Conditional Sum Wizard in an Excel workbook, follow these steps:
 * 1) On the Help menu, click Contents and Index, click Index, and then click C.
 * 2) Scroll down until you locate condition, and then click the arrow to the left to view a list of topics under the general topic.
 * 3) 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.

Additional query words: off2001kb mac XL2001KB

Keywords: kbbug kbpending KB272889

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.