Circular references

[julhs]

How do I search a worksheet for a circular reference that Excel knows exists but can’t list for me. No formula changes have been made recently, sheet is full of array formula and condition formatting etc

 

[dikken20]

How do I search a worksheet for a circular reference that Excel knows exists but can’t list for me. No formula changes have been made recently, sheet is full of array formula and condition formatting etc

I'm having just the same issue.
Have you found any solution for that?

Maybe someone else here knows the answer?

 

[Joe4]

Do you have iterative calculations turned on?
If so, according to the document below, you need to turn those off in order for Excel to find those circular references for you.

Circular reference in Excel: how to find, enable, use, or remove

Learn the basics of Excel circular reference - how to check workbooks for circular formulas, and how to enable, find and remove circular references in Excel.

www.ablebits.com

 

[mischifous]

I'm having the same issue. No iterative calculations are turned off.
This can't be a unique issue, i'm having this with several workbooks and checking each formula manually just is not a realistic solution.

 

[Alex Blakenburg]

There is a macro here if you want to give that a go.
Find circular references within your workbook

 

[mischifous]

There is a macro here if you want to give that a go.
Find circular references within your workbook

works like a charm. you're awesome than kyou

 

[julhs]

Not that I found it easy to find the culprit manually, I did eventually!!!

I've not tried Alex's suggestion, but I will certainly keep it in the arsenal for future.

 

[Alex Blakenburg]

works like a charm. you're awesome than kyou

Glad we could help. Thanks for the feedback.

@julhs - thanks for the update.