Circular Reference Problem

[CDelSignore]

I have a workbook with many tabs and use the same formula on some of them. The formula?

=TODAY()-(WEEKDAY(TODAY(),2))-7​

One just one of at least 4 tabs that uses this exact equation, I get a Circular Reference warning. It's not really causing any issues as it produces correct info, but it's annoying. Any idea why only one tab would be have this issue?

 

[Joe4]

The formula you posted has no range references, so I don't see how it could return that warning.
- Are you absolutely sure that is the EXACT formula returning the Circular Reference warning (make sure there is a letter in front of the 2 or 7 number in the formula)?
- Are your sure it isn't a formula in a different cell returning the error?
- Do you have any named ranges on that sheet? If so, what are the names?

 

[Special-K99]

If you have any < > characters in the formula then put spaces around them when posting here as the forum hides the < > characters making formulas impossible to read.

 

[CDelSignore]

The formula you posted has no range references, so I don't see how it could return that warning.
- Are you absolutely sure that is the EXACT formula returning the Circular Reference warning (make sure there is a letter in front of the 2 or 7 number in the formula)?
- Are your sure it isn't a formula in a different cell returning the error?
- Do you have any named ranges on that sheet? If so, what are the names?

@Joe4: Yes, that is the exact formula/cell. Lower left hand corner identifies that cell as the location of the circular reference warning.
@Special-K99: I didn't know that about the greater than/less than symbols. Thank you for that tip. My formula does not contain them, though.

When I click on Error Checking, I get a pop up saying it was complete for the entire sheet. I only get the warning when I calculate the entire sheet (I have it set to manual, not autocalculate). When I click on the Error Checking dropdown, Circular References is grayed out, even.

 

[Joe4]

Lower left hand corner identifies that cell as the location of the circular reference warning.

I thought those were typically in the upper left corner of a cell, not the lower left corner.

What about my question regarding named ranges?

 

[CDelSignore]

No Named Ranges.

I purposely created a couple circular references (sums including the cell with the formula) and there was no formula error drop down next to the cell. I do know what you're talking about, though.

 

[Joe4]

Rather odd...

If you delete the formula from that cell, does the Circular Reference warning go away?

 

[Joe4]

There are some techniques mentioned here that may help in diagnosing it:
https://support.office.com/en-us/ar...eference-8540bd0f-6e97-4483-bcf7-1b49cd50d123

 

[CDelSignore]

Yes, the warning does go away.

 

[Joe4]

I have no explanation. I cannot recreate that behavior.
Without having access to the workbook, I don't think there is anything I can do.