circular references

  • Thread starter Thread starter victoria
  • Start date Start date
Correct formulas so that they do not include themselves?

Better yet -- Excel has a very good section in their online help regarding
Circular refernces

: how do I eliminate circular references within a document?
 
The mechanics of removing CRs are simple: Choose
View/Toolbars/Circular reference, and use the dropdown to identify
the cells with formulae that are dependent on their own output
(perhaps via one or more intermediate cells). Change the formula.

The repair/replacement of your shee's design/logic sometimes is
difficult. Post back with more details if you need help with that.
 
Back
Top