View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] robzrob@hotmail.com is offline
external usenet poster
 
Posts: 5
Default Circular Reference

On Sep 12, 10:33*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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



On Sat, 12 Sep 2009 12:38:08 -0500, Chip Pearson wrote:
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)


On Sat, 12 Sep 2009 09:12:47 -0700 (PDT), wrote:


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?- Hide quoted text -


- Show quoted text -


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