Microsoft KB Archive/264850

= XL2000: INDIRECT Function Using R1C1 Calculates Incorrectly If Chart Is Selected =

Article ID: 264850

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q264850





SYMPTOMS
In Microsoft Excel 2000, the INDIRECT worksheet function may return incorrect results when the workbook in which it is used is recalculated.



CAUSE
The problem occurs when all of the following conditions are true:
 * The INDIRECT function uses an R1C1 reference.

-and-


 * The R1C1 reference is relative (for example, R[1]C[0]).

-and-


 * An embedded chart or chart sheet was selected when the workbook was recalculated.



WORKAROUND
To work around this problem, make sure the embedded chart or chart sheet is not selected by selecting a worksheet cell before you recalculate the workbook.



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

Additional query words: XL2000 calc recalc

Keywords: kbbug kbpending KB264850

-

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

© Microsoft Corporation. All rights reserved.