Article ID: 186395
Article Last Modified on 10/21/2000
APPLIES TO
- Microsoft Excel 97 Standard Edition
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).
MORE INFORMATION
Example of the Problem
To see an example of the problem, follow these steps:
- Save and close any open workbooks and open a new workbook.
- Type the value 1 into cell A1.
Type the following formula into cell B2:
=$A$1:$A$1+1
The formula returns a value of 2.
- Fill the formula in cell B2 (using the Fill handle) down to cell B5.
The cells in the range B2:B5 will display a value of 2. - Change the value in cell A1 to 4.
Only cell B2 will display the correct value of 5.
Additional query words: XL97 recalc
Keywords: kbbug kbfix KB186395
