Microsoft KB Archive/918770

= Circular reference arrows are drawn in the wrong cells of a worksheet in Excel 2007 =

Article ID: 918770

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
In Microsoft Office Excel 2007, when you recalculate a worksheet that contains circular references, the circular reference arrows are drawn in the wrong cells of the worksheet.

Note To recalculate the current worksheet in Excel 2007, press F9.



CAUSE
This issue occurs when one of the following conditions is true:
 * You are running Excel 2007 on a multiprocessor computer.
 * You are running several instances of Excel 2007 at the same time.



WORKAROUND
To work around this issue, use one of the following methods:
 * Run the recalculation on a single-processor computer. If you are running Excel 2007 on a multiprocessor computer, follow these steps:
 * On the Microsoft Office Button, click Excel Options.
 * Click Advanced.
 * In the Formulas section under Advanced options for working with Excel, click Manual, and then change the number of processors to 1.
 * Exit all other instances of Excel 2007.

Additional query words: excel2007 excel2k7 excel12 xl2007 xl2k7 xl12

Keywords: kbtshoot kbprb kbformula kbexpertisebeginner KB918770

-

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

© Microsoft Corporation. All rights reserved.