Thread: Excel says non-circular references are circular.
View Single Post
 
Old 04-17-2021, 02:49 PM
coffent coffent is offline Windows 10 Office 2019
Advanced Beginner
  
Join Date: Dec 2019
Posts: 40
coffent is on a distinguished road
Default Excel says non-circular references are circular.
Excel claims I have all sorts of circular references. For example, in cell M8 I have the formula:

=INDIRECT("C" & D3)

The value of D3 is the number 14, so the reference is to cell C14. The value of cell C14 is the number 96, so the value in cell M8 should be, and is, 96. Yet in the Status Bar Excel says "Circular References: M8". Why?
Reply With Quote