Circular Reference

  • Thread starter Thread starter robzrob
  • Start date Start date
R

robzrob

I've got a workbook with some formulae with (deliberate) circular
references in them. They've suddenly stopped working. Is there
anything the user might have done to make this happen?
 
In the Calculation Options, ensure that Iteration is enabled and set
to the appropriate value (probably 1).

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
For OP

If the circ refs were working before and iterations set properly, perhaps
user just set calculation mode to manual.


Gord Dibben MS Excel MVP
 
For OP

If the circ refs were working before and iterations set properly, perhaps
user just set calculation mode to manual.

Gord Dibben  MS Excel MVP







- Show quoted text -
Click to expand...

Have tried re-setting Calc Mode - nothing. I've got this in COL B: =IF
(C1742="","",IF(B1742="",NOW(),B1742)), COL B formatted for date, and
this in COL C: =IF(D1742="","",IF(C1742="",NOW(),C1742)), COL C
formatted for time. Normally, as soon as an entry is made in D1742
(and D1743, D1744 and so on down the rows), date appears in COL B and
time appears in COL C. It stopped working after ROW 1749. I've got 6
workstations with 1 workbook for each workstaion, so I've got 5 other
workbooks like this and they're all still working. Are there any
comparisons I could make between them which might show something up?
 
For OP

If the circ refs were working before and iterations set properly, perhaps
user just set calculation mode to manual.

Gord Dibben  MS Excel MVP







- Show quoted text -
Click to expand...

Also, on Open, it's giving me a warning about the workbook containing
circular references, which it never used to do.
 
Back
Top