XL97: Custom Function Is Not Recalculated with Intersection Operator (186685)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q186685 SYMPTOMS
When you calculate values on a worksheet, some formulas may not be
automatically updated.
CAUSE
This problem may occur when the following conditions are true:
- The formula calls a custom function.
-and-
- The formula refers to a cell an another worksheet.
-and- - You use the Intersection operator in one of the arguments in the custom
function.
RESOLUTION
To correct this problem, obtain Microsoft Excel 97 Service Release 2
(SR-2).
For additional information about SR-2, please see the following article
in the Microsoft Knowledge Base:
151261
OFF97: How to Obtain and Install MS Office 97 SR-2
To work around the problem temporarily, press CTRL+ALT+F9 to recalculate
the values in the entire workbook.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for
Windows. This problem was corrected in Microsoft Office 97 Service Release
2 (SR-2).
Modification Type: | Major | Last Reviewed: | 10/21/2000 |
---|
Keywords: | kbbug KB186685 |
---|
|