circular reference

Copper Contributor

I keep getting a "Circular Reference" warning, but the cell specified has a "randbetween" formula.  How the H-E-Double hockey sticks does that constitute a circular reference?

1 Reply
Depends on your formulas I guess. check out my reftreeanalyser tool, which will locate all active circular references: https://jkp-ads.com/reftreeanalyser.asp