XL97: Formulas with Range-Style Cell Reference Are Not Updated (186395)
The information in this article applies to:
- Microsoft Excel 97 for Windows
This article was previously published under Q186395 SYMPTOMS
When you calculate values in your Microsoft Excel worksheet, some cells may
not be automatically recalculated.
CAUSE
This problem may occur when you use formulas that contain a range-style
reference to a single cell. For example, a formula that uses the following
reference style to refer to cell B5 may not be recalculated:
$B$5:$B$5
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, change the style of the cell
references. For example, change the following cell reference
$B$5:$B$5
to:
$B$5
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 KB186395 |
---|
|