is there a workaround for circular reference error

C

Charles Williams

Sure:

You can either fix the error by changing your formulae so that you do not
have a circular reference, typically by inserting an extra step.
for example calculate funds_before_interest, the interest on the
funds_before_interest and then funds_after_interest

Or if you really have a circular system you can use Iteration
(Tools-->Options-->Calculation-->Iteration), but be careful because this
tends to make it more difficult to find errors.

Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top