Home

circular reference

%3CLINGO-SUB%20id%3D%22lingo-sub-834136%22%20slang%3D%22en-US%22%3Ecircular%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834136%22%20slang%3D%22en-US%22%3E%3CP%3EI%20keep%20getting%20a%20%22Circular%20Reference%22%20warning%2C%20but%20the%20cell%20specified%20has%20a%20%22randbetween%22%20formula.%26nbsp%3B%20How%20the%20H-E-Double%20hockey%20sticks%20does%20that%20constitute%20a%20circular%20reference%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-834136%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-834605%22%20slang%3D%22en-US%22%3ERe%3A%20circular%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-834605%22%20slang%3D%22en-US%22%3EDepends%20on%20your%20formulas%20I%20guess.%20check%20out%20my%20reftreeanalyser%20tool%2C%20which%20will%20locate%20all%20active%20circular%20references%3A%20%3CA%20href%3D%22https%3A%2F%2Fjkp-ads.com%2Freftreeanalyser.asp%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fjkp-ads.com%2Freftreeanalyser.asp%3C%2FA%3E%3C%2FLINGO-BODY%3E
YankFanLarry
Occasional Visitor

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
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
48 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies