Circular reference, Indirect, and Sum

[cmrandom22]

Hello everyone,

Every time I open an excel worksheet, I get an error complaining about
circular reference.

The code I'm using is: =SUM(INDIRECT("H10:"&ADDRESS(ROW
()-1,8))) ,which says: Add the rows starting from H10 to the position
at row above current cell, column #8.

I can simplify the formula and still reproduce a circular reference
warning by having the formula: SUM(INDIRECT
("A1:A2")), and this formula is located in cell A3.

How do I fix this error?

cmrandom22

 

[David Biddulph]

The formula =SUM(INDIRECT("A1:A2")) in cell A3 does not give a circular
reference, so your fault is presumably elsewhere in the sheet.

If you type "circular reference" into Excel help, you'll see a topic "Allow
or correct a circular reference". It'll show you how to find where your
problem occurs.

 

[Eduardo]

Hi,
for your second example I guess is another formula somewhere in your
spreadsheet. when you receive the warning, click in details and see which
formula is causing problems, another way is click in trace precedents or
error checking

 

[ryguy7272]

View > Toolbars > Customize > Circular Reference > Close. Then, click the
down arrow in the little rectangle area.

HTH,
Ryan---