Circular:G4?

[WTG]

My spread sheet has slowed down considerably, and I've notice on the
very bottom bar of my excel sheet it now shows

Circular:G4

What does this mean?
And could one thing have anything to do with the other?

My formula in G:4 is as follows:

=IF(B4>0,IF(SUMIF(P_Invoice!B4:B10002,P_Cheques!C4,P_Invoice!F4:F10002)=P_Cheques!D4,"Pd","UnPd"),0)

Thanks for your help.

Wally

 

[Bob Phillips]

It means that you have a cell that is referencing itself, either directly,
or indirectly via a formula in another cell.

Check to see if P_Invoice!B4:B10002,P_Cheques!C4, P_Invoice!F4:F10002, or
P_Cheques!D4 has a formula that refers back to G4, or a range containing G4.
Then you need to correct it.
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

It's time to get your deerstalker, Mr Holmes!

A circular reference means that one of the references in the formula in cell
G4 is using the result of cell G4.
Kind of like saying:
x = 2*A
A= 3*Z
z = 6*x

You need to track where G4 is used, then look at where those cells are used
and so on.
Somewhere along the line you'll come back to G4. Once you break that
circular calculation everything will run properly again.

HTH

Giz

 

[Dave Peterson]

If you have trouble finding the circular reference, maybe Stephen Bullen's
utility will help:

http://www.oaltd.co.uk/Excel/Default.htm
Look for FindCirc.zip

 

[WTG]

Thanks

I found the problem cell and the sheets running fine.

Thank you again

Wally