Microsoft KB Archive/235596

= XL98: Formula Is Not Updated Correctly When Data Changes =

Article ID: 235596

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q235596



SYMPTOMS
When you change the data that a formula refers to, the formula is not updated correctly. If you press COMMAND+= to recalculate the workbook, it does not correct the problem. This problem occurs even when the calculation method is set to automatic.



CAUSE
This problem occurs when the following conditions are true:
 * A formula refers to another cell in the same row.

-and-
 * You copied the formula from another cell by using any of the following methods:
 * Copy and Paste commands
 * Dragging the fill handle
 * The Fill-Down command



WORKAROUND
To correct this problem in your formula, double-click the cell that contains the formula, and then press RETURN. Or, click the cell, press COMMAND+U, and then press RETURN. This forces Excel to recalculate the formula. Excel continues to update any subsequent changes to dependent cells correctly.



STATUS
Microsoft has confirmed that this is a problem in Microsoft Excel 98 Macintosh Edition.

Additional query words: Macintosh Office 98 fill handle XL98

Keywords: kbbug kbnofix KB235596

-

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

© Microsoft Corporation. All rights reserved.