XL98: Formulas with Range-Style Cell Reference Are Not Updated (191645)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
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:
WORKAROUND
To work around the problem, change the style of the cell references. For
example, change the following cell reference
to:
STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 98
Macintosh Edition.
Modification Type: | Major | Last Reviewed: | 9/11/2002 |
---|
Keywords: | kbbug KB191645 |
---|
|