Microsoft KB Archive/264851

= XL97: INDIRECT Function Using R1C1 Calculates Incorrectly with Chart Selected =

Article ID: 264851

Article Last Modified on 3/16/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q264851



SYMPTOMS
The INDIRECT worksheet function may return incorrect results when the workbook in which it is used is recalculated.



CAUSE
This problem occurs when all of the following conditions are true:
 * The INDIRECT function uses an R1C1 reference.
 * The R1C1 reference is relative; for example, R[1]C[0].
 * An embedded chart or chart sheet is selected when the workbook is recalculated.



WORKAROUND
To work around this problem, activate a worksheet 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: recalc

Keywords: kbbug KB264851

-

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

© Microsoft Corporation. All rights reserved.