Circular reference help

[splot!]

Hello, does anyone know whether it is possible to stop Excel 2007 from
firing up Help whenever it gets a circular reference, please?

I have some spreadsheets which, after updating data-links, form
circular references. This is easily corrected by moving some totals
in line with the updated data. I don't disagree with Excel prompting
me that the circular references exist but I do not want it to fire up
the help system. I know the issue and I am just about to fix it, the
only thing delaying me is the Help window getting in the way.

Regards

Chris

 

[Bob Umlas]

easiest way is Office button/Excel Options/Formulas/ check "Enable Iterative
calculation"

 

[splot!]

Thanks Bob,

That, I think, will not just stop Help from being fired up but will
also stop the error message. I'm not sure this is necessarily a good
idea as there may be other times when a circular reference occurs
which I am not expecting.
Ho hum, compromise. compromise.

REgards

Chris

 

[Chip Pearson]

The settings that apply to circular references are global in scope. If
you turn on the "Iterations" setting, circular references are always
allowed, with no warning, in any cell. If "Iterations" is cleared,
you'll always get the help for every circular reference. There is no
way to allow a circular reference only in specific cells.

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

 

[splot!]

OK thanks for the confirmation Chip.
I suppose it's a symptom of nanny-programming that assumes yu need
help just because you have made an error, rather than just opointing
it out :-(

Cheers

Chris