Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Circular reference does not calculate during Range.Calculate execution in Excel 2002
Article ID: 827990 - View products that this article applies to.
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 "Resolution" section is installed.
How to obtain the hotfixThis 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:
(http://support.microsoft.com/kb/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.
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.