Circulair error message

F

Frank Situmorang

Hello,

We using Excel 2007 and the our previous worksheet in E2002 is aready saved
as E2007. This just happened 1 day ago, that when we type the worksheet the
following error message pops up and when we clicked OK it does not show the
circulair cell tracking.

Circular Reference Warning
One or more formulas contain a circular reference and may not calculate
correctly. Circular references at any references within a formula that depend
upon the results of that same formula. For example, a cell that refers to its
own value or a cell that refers to another cell which depends on the original
celss's value both contain circular references.

For more information about understanding, finding, and removing circular
references, click

OK. If you want to create a circular reference, click Cancel to continue.

Pls. help how can we solve the problem,

Thanks in advance
 
B

Bernard Liengme

You need to locate the circular error
For example if =SUM(A1:A10) in in cell A10 you have a circular error
It is a formula that refers to itself or a cell that is dependent on it.
This is not changed in XL 2007, all version had this error checking feature.

Use Formulas | Formula Auditing | Trace Precedents to help you locate the
'circle'
best wishes
 

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