|
|
#1
04-17-2021, 02:49 PM
|
|||
|
|||
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? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Circular Reference - Getting Around It | Pluviophile | Excel | 3 | 09-19-2020 01:19 PM |
| circular reference | riothecat | Excel | 6 | 06-29-2017 10:56 AM |
| "Circular References," but formatted as text | newmaven | Excel | 3 | 12-13-2016 02:23 PM |
 Circular Reference Warning in Excel Sheet.
|
Rahmat_uk20 | Excel | 3 | 06-08-2012 02:31 AM |
| Circular error | markg2 | Excel | 2 | 05-17-2010 07:39 AM |
Windows 10 
Office 2019
Threaded Mode