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

HTH,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Eduardo" wrote:

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

"cmrandom22" wrote:

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