Microsoft KB Archive/211784

= XL2000: Linked Cell Changes Before Sheet Is Completely Calculated =

Article ID: 211784

Article Last Modified on 9/27/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211784





SYMPTOMS
When you select a value in an ActiveX control, the value of the linked cell may not match the value that you select in the control.



CAUSE
This problem can occur when the values in the ActiveX control are derived from formulas or functions that are recalculated when the worksheet changes. For example, the problem occurs if you create a List Box control that is populated by a range of cells on the worksheet and the values in the cells are calculated using a volatile function.



WORKAROUND
To work around this problem, use the manual calculation method for the workbook. To correctly use the calculation method for the workbook, follow these steps:
 * 1) On the Tools menu, click Options.
 * 2) On the Calculation tab, click Manual, and then click OK.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
In Microsoft Excel 2000, you can insert ActiveX controls on a worksheet and populate the control with data on the worksheet by using the ListFillRange property. However, if the data is volatile, cells linked to the control may be recalculated before the data updates the control. This behavior causes the value in the linked cell to be different from the value that you select in the control.

Functions that are recalculated automatically when data in the worksheet changes are volatile functions. The following functions are volatile:

AREAS

INDEX

OFFSET

CELL

INDIRECT

ROWS

COLUMNS

NOW

RAND

Additional query words: list box edit combination dropdown XL2000

Keywords: kbbug kbpending KB211784

-

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

© Microsoft Corporation. All rights reserved.