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