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(B40,IF(SUMIF(P_Invoice!B4:B10002,P_Cheques!C4 ,P_Invoice!F4:F10002)=P_Cheques!D4,"Pd","UnPd"),0)

Thanks for your help.

Wally

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)

"WTG" wrote in message
...

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(B40,IF(SUMIF(P_Invoice!B4:B10002,P_Cheques!C4 ,P_Invoice!F4:F10002)=P_Ch
eques!D4,"Pd","UnPd"),0)

Thanks for your help.

Wally

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

"WTG" wrote:


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(B40,IF(SUMIF(P_Invoice!B4:B10002,P_Cheques!C4 ,P_Invoice!F4:F10002)=P_Cheques!D4,"Pd","UnPd"),0)

Thanks for your help.

Wally

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 wrote:

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(B40,IF(SUMIF(P_Invoice!B4:B10002,P_Cheques!C4 ,P_Invoice!F4:F10002)=P_Cheques!D4,"Pd","UnPd"),0)

Thanks for your help.

Wally

--

Dave Peterson

Thanks

I found the problem cell and the sheets running fine.

Thank you again

Wally


On Thu, 20 Apr 2006 08:14:27 -0400, WTG
wrote:


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(B40,IF(SUMIF(P_Invoice!B4:B10002,P_Cheques!C 4,P_Invoice!F4:F10002)=P_Cheques!D4,"Pd","UnPd"),0 )

Thanks for your help.

Wally