Keep Getting Circular Reference

[jerk21189]

Hi there,

My excel file keeps giving me circular reference status no matter how I changed my formula. Even if I randomly typed =IF(OFFSET(G64,0,2)<>0,0,1) in the formula bar, where G64 is simply a blank cell, it keeps saying this is circular reference. How can I solve this? Thanks!

 

[Rick Rothstein]

Hi there,

My excel file keeps giving me circular reference status no matter how I changed my formula. Even if I randomly typed =IF(OFFSET(G64,0,2)<>0,0,1) in the formula bar, where G64 is simply a blank cell, it keeps saying this is circular reference. How can I solve this? Thanks!

The circular reference is not dependent on cell G64, rather, it is dependent on cell I64 (the cell 2 columns offset from G64).

 

[jerk21189]

The circular reference is not dependent on cell G64, rather, it is dependent on cell I64 (the cell 2 columns offset from G64).

Thanks very much! However, I64 was also a blank cell. Any idea why I keep getting that error note?

 

[Rick Rothstein]

Thanks very much! However, I64 was also a blank cell. Any idea why I keep getting that error note?

Cell I64 is blank... it does not have a formula in it? If that is the case, then I am afraid I cannot tell you why you are getting that error. Maybe if we can see your workbook (assuming it is not referencing any foreign files or other workbooks), then maybe we could see the error happening and try and trace it from there. Any chance you can post a copy of the workbook to, say, DropBox so that we can download it ourselves?

 

[jerk21189]

Cell I64 is blank... it does not have a formula in it? If that is the case, then I am afraid I cannot tell you why you are getting that error. Maybe if we can see your workbook (assuming it is not referencing any foreign files or other workbooks), then maybe we could see the error happening and try and trace it from there. Any chance you can post a copy of the workbook to, say, DropBox so that we can download it ourselves?

Hi Rick,

Thanks very much for your kind help. The file is attached here. In the "Rent Roll" Tab, Cell I72, where I also put a comment, keeps getting circular reference error, even though I just enter a random blank cell reference. Thanks again!

Dropbox - MrExcel.xlsx

 

[Peter_SSs]

"Rent Roll" Tab, Cell I72, where I also put a comment, keeps getting circular reference error,

In that cell I see no circular reference error (and no comment either)

 

[jerk21189]

In that cell I see no circular reference error (and no comment either)

Extremely sorry.

Attaching the link again. Also attaching the screencap that shows the circular reference error:

Dropbox - Screencap Excel.png
Dropbox - MrExcel v2.xlsx

 

[Peter_SSs]

Still no Circular Reference error for me in cell I72. Have you removed anything from cell F67 before sharing the file with us?