Microsoft KB Archive/191645

= XL98: Formulas with Range-Style Cell Reference Are Not Updated =

Article ID: 191645

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q191645





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



WORKAROUND
To work around the problem, 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 98 Macintosh Edition.



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 5 into cell A1. Type the following formula into cell B1:

=$A$1:$A$1+1

The formula returns a value of 6. Fill the formula in cell B1 (using the Fill handle) down to cell B5.

The cells in the range B1:B5 will display a value of 6. Change the value in cell A1 to 1.

Only cell B1 will display the correct value of 2.</li></ol>

Additional query words: XL98 recalc

Keywords: kbbug kbpending KB191645

-

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

© Microsoft Corporation. All rights reserved.