Circular reference

[leon]

I need to know how to copy the results of the cummulative claims to the
previous claims row.
In order to submit a new claim the previous claims cummulative should be
13,000 and then
I need to delete the current claim amount and enter the new claim amount. I
get a circular
reference when I try to copy since it is a formula. Can anyone help me?
Code Description Approved Budget Previous Claims - Cummulative Current
Claim Cummulative Claims Remaining Budget
i. Salaries 50,000.00 10,000.00 3,000.00
13,000.00 37,000.00
ll. Fringes 10,000.00 3,000.00 1,000.00
4,000.00 6,000.00
iii. Travel 5,000.00 2,000.00 1,000.00
3,000.00 2,000.00
Total 65,000.00 15,000.00 5,000.00 20,000.00
45,000.00

 

[BrianB]

The only way of checking a circular reference is to look at individua
cells to see which references are contained there and follo
backwards.

You should see a message in the status bar at the bottom "Circula
Reference :"
and a cell reference to start off with. If you cannot see it, you nee
to tab through your sheets until you do.

Using Tools/Auditing/.... can help with this. Click in a cell and us
Trace Precedents or Trace Dependents