Circular reference toolbar not working
Hi!
Iterations are working. EG 500 iterations increases the values by 1000
If you set iteration *before* you actually create the circular reference
(either intentional or accidental) you'll get no warning but you should see
"Calculate" in the Status bar.
If you create the circular reference without setting iteration then you'll
get the pop-up warning. If you select "OK" from the warning dialog then the
toolbar opens.
Biff
wrote in message
oups.com...
If I create a circular reference purposely, the circular reference
toolbar does not appear and no warning is displayed.
The "Formula Auditing" toolbar's Evaluate Formula button correctly
identifies the circular reference, but when I force the "Circular
Reference" toolbar out of hiding (customise, etcetera), the "Navigate
Circular Reference" combo box is empty. It remains empty even when I
select or activate the cell containing the circular reference.
The reference needn't be anything complex.
E.G.
A1 = A2
A2 = A1
Iterations are working. EG 500 iterations increases the values by 1000
Automatic calculation is also working fine.
Excel 2002 SP3.
How can I get the Circular Reference toolbar to function correctly?
|