The information in this article applies to:
SYMPTOMSA formula in a merged cell that contains a reference to a cell that contains another formula does not appear to be updated when the referenced value changes. CAUSE
This problem is a screen updating problem rather than a calculation
problem. You can verify this by selecting a range of cells including the
cell with the incorrect value and checking the sum in the status bar. That
sum reflects the correct cell value.
-and- -and- WORKAROUNDTo work around this problem, do either of the following:
-or- STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. MORE INFORMATION
You can force the cell to be updated by selecting another sheet or another
area of the sheet and then selecting the cell again. However further
changes may not be reflected until the screen is redrawn again.
REFERENCESFor more information about merging cells, click the Index button in Excel 98 Macintosh Edition, type the following text merging cellsand then double-click the selected text to go to the "Merge cells to span several columns or rows" topic. Additional query words: XL98
Keywords : kbdta xlformat xlformula |
Last Reviewed: January 13, 2000 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |