Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Circular reference toolbar not working

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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Circular reference toolbar not working

Nevermind.

It seems the Circular Reference error/toolbar is not shown when
iterations are turned on and this dependency is not documented in the
help file.

  #3   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Circular reference toolbar not working

Thanks Biff. That matches what I have seen now.

The relevant circular reference was only counting the cells in a column
above a rolling point from a fixed point, including the current cell,
as a condition for determining which of two formulae to use in order to
produce a discontinuous function. So the actual calculation (aside
from the choice of which to use) was unaffected by the circular
reference. I can understand why the circular reference subsystem would
leave out the nuance of whether an end calculation was affected - too
many possibilities.

In the end, I excluded the current cell from the count and added 1.
Same effect, no more circular reference!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What is a circular reference $B$11 and how do I delete it? lance559 Excel Discussion (Misc queries) 3 February 22nd 06 06:50 PM
Problem with Circular Reference Paul M Excel Discussion (Misc queries) 1 February 15th 06 02:43 AM
Create dictionary of terms, create first time user site Solitaire Jane Austin New Users to Excel 1 January 19th 06 10:47 PM
circular reference when using a UDF Saira Excel Worksheet Functions 1 September 21st 05 06:39 PM
Circular reference leon Excel Worksheet Functions 1 November 1st 04 01:45 PM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"