If the circular reference is on that same sheet you should see the wordĬircular: followed by the cell reference of the 'first' circular reference in the sheet. Depending on the nature of the circular reference, blue Tracer arrows may appear as well.Īnother visual indicator is that cells containing a circular reference typically will return a 0 result even if the dot isn't displayed.Īlso, take a look at the Status Bar. Recalculate Sheet or Recalculate All button on theįormulas tab then look again. In Excel 2011 you may see a blue dot in a cell containing the circular reference. Normally, that message only appears when attempting to enter a formula that contains the circular reference, so the problem should be with the formula being entered into that particular cell.
