XL97: INDIRECT Function Using R1C1 Calculates Incorrectly with Chart Selected (264851)


The information in this article applies to:

  • Microsoft Excel 97 for Windows
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.
Modification Type:MajorLast Reviewed:3/16/2001
Keywords:kbbug KB264851
©2002 Microsoft Corporation. All rights reserved.