Microsoft KB Archive/827990

= Circular reference does not calculate during Range.Calculate execution in Excel 2002 =

Article ID: 827990

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2002 Standard Edition

-



SYMPTOMS
When you use the Range.Calculate method or the Rows.Calculate method in Microsoft Visual Basic for Applications (VBA), and the range contains all the cells in a circular reference, the calculation does not occur and there is no error message returned.

Note A problem exists in versions of Excel that are earlier than Excel 2002 that causes those versions of Excel not to correctly calculate circular references in some cases. This problem may occur when you try to calculate only a range within a worksheet by using the VBA Range.Calculate method or the Rows.Calculate method. Because of this problem, this particular scenario is disabled in Excel 2002 when the hotfix that is mentioned in the &quot;Resolution&quot; section is installed.



How to obtain the hotfix
This issue is fixed in the Excel 2002 Post-Service Pack 2 Hotfix Package. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

827143 Excel 2002 post-Service Pack 2 hotfix package: August 28, 2003

The hotfix creates a runtime error message that notifies the programmer when the cells in question do not calculate. This error message will appear whenever the Range.Calculate method is used with iterations turned on.



WORKAROUND
To work around this issue, calculate the whole worksheet instead of just a range in the worksheet by using the Worksheet.Calculate method.

Another workaround that you can try is to turn off iterations before you calculate the range. This workaround works in some cases but not in all cases.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: XL2002

Keywords: kbqfe kbhotfixserver kbbug kbfix kbofficexppresp3fix KB827990

-

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

© Microsoft Corporation. All rights reserved.