You receive a run-time error message when you run the Conditional Sum Wizard add-in in Excel 2003 (885245)
The information in this article applies to:
- Microsoft Office Excel 2003
SYMPTOMSWhen you try to use the Conditional Sum Wizard add-in to enter a formula in Microsoft Office Excel 2003, you may receive the following error message:
Run-time error '1004':
Unable to set the FormulaArray property of the Range class
CAUSE
This problem occurs if you enter a condition in the Conditional Sum Wizard that contains a value that is not contained in the selected cell range.
RESOLUTIONThis problem was first fixed in a hotfix that is now contained in a service pack. If you installed the latest Office 2003 service pack, you do not have to install the hotfix. Service pack informationThis problem is corrected in Office 2003 Service Pack 2. To resolve this problem, obtain the latest service pack for Office 2003. For more information, click the following article number to view the article in the Microsoft Knowledge Base: 870924 How to obtain the latest service pack for Office 2003 Hotfix informationHow to obtain the hotfixThis issue is fixed in the Microsoft Office Excel 2003 Hotfix Package that is dated September 2, 2004. For additional information, click the following article number to view the article in the Microsoft Knowledge Base: 885234 Description of the Excel 2003 post-Service Pack 1 hotfix package for the Conditional Sum Wizard add-in: September 2, 2004 STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Office 2003 Service Pack 2.
| Modification Type: | Major | Last Reviewed: | 5/15/2006 |
|---|
| Keywords: | kbOffice2003SP2fix kbAddIn kbOffice2003preSP2fix kbQFE kbbug kbfix kbHotfixServer KB885245 kbAudITPRO kbAudEndUser |
|---|
|