circular referencing

[john]

I have two identical tables within the same spreadsheet.
The table on top is for dumping information into, and the
table on the bottom keeps a running tally of each data
dump in the first table. Excel is saying that I have a
circular reference and I'm not sure how to use this.

What's the secret?

 

[Harlan Grove]

I have two identical tables within the same spreadsheet.
The table on top is for dumping information into, and the
table on the bottom keeps a running tally of each data
dump in the first table. Excel is saying that I have a
circular reference and I'm not sure how to use this.

What's the secret?

Apparently one of the big secrets to newsgroups is waiting for a response to
your original question and DON'T litter newsgroups with separate multiple
instances of the same question.

Without seeing the formulas in both of your tables, it's not possible to say
with any certainty. So, if you want a useful answer, provide details. Excel DOES
tell you where it thinks the circular reference occurs. Start there and paste
into your follow-up the *EXACT* formula in that cell as well as the formulas in
all cells referenced in the first formula.

 

[Biff]

Hi John,

Look at the status bar to see where the circular reference
is. You should see something like - Circular:B20. This
means that a reference in the formula refers to the
formulas result itself. To get the formula to calculate:

Tools>Options>Calculation. Select Iteration

Be aware though that with this option selected, you
*can/will* get incorrect results in other formulas in the
sheet.

This option is for highly specialized situations and under
the right conditions. You should avoid this as much as
possible. 99.999% of the time a circular reference is not
necessary or desireable.

You should correct the problem. Sometimes the circular
reference is not so obvious and may take some clever
workaround.

Biff

 

[john]

well no one was responding to my question you jerkoff,
don't worry about me

 

[Intruder9]

You know what, no one on these newsgroups are your personal secretaries and
we all work and your question gets answered when it gets answered, calling
people names shows your IQ level and will insure no one ever helps you.
Don't let the door hit you in the arse on the way out.Good Luck and GOOD
BYE!!!!!!!!

 

[ricky schroeder]

blow me asshole

-----Original Message-----
You know what, no one on these newsgroups are your personal secretaries and
we all work and your question gets answered when it gets answered, calling
people names shows your IQ level and will insure no one ever helps you.
Don't let the door hit you in the arse on the way out.Good Luck and GOOD
BYE!!!!!!!!



.

 

[Intruder9]

Come on over Mr. Bobbit and we sure will take care of ya.

 

[Harlan Grove]

I have two identical tables within the same spreadsheet.
The table on top is for dumping information into, and the
table on the bottom keeps a running tally of each data
dump in the first table. Excel is saying that I have a
circular reference and I'm not sure how to use this.

....

You seem to have missed the remainder of my original response.

Without seeing the formulas in both of your tables, it's not possible
to say with any certainty. So, if you want a useful answer, provide
details. Excel DOES tell you where it thinks the circular reference
occurs. Start there and paste into your follow-up the *EXACT* formula
in that cell as well as the formulas in all cells referenced in the
first formula.

This still remains the case whether or not you care to read anything more
that I write. If you don't provide details, no one else can provide any
meaningful help. If you're not here to seek help, fine. However, if you are,
you're going to need to provide details even if doing so is intensely
painful as you'd be doing something I told you to do.

 

[Me]

...you jerkoff

That guy really knows what he's talking about!