Circular Reference warning, when there is none

Copper Contributor

My Excel 2016 is giving me the 'circular reference' warning after about every 3rd, or 4th cell, no matter if it is text or number.  I even tried it on a fresh spreadsheet with absolutely no formulas.  This started a couple weeks ago, as an occasional thing, but now it happens steadily, no matter which (of several) spreadsheet I am using.  It happens whether I am entering down a column, or across a row - numbers or text.

It takes 3-5 seconds for each number to 'register' and move to the next cell.

I use spreadsheets all day long and this is slowing my data entry to a near-stop, because I have to wait after keying each cell, then kill the message box each time it pops up.

I have tried shutting down, and re-starting my computer, and that makes no difference.

I have also tried 'error checking' in the formulas tab, going through every sheet of a spreadsheet set.

 

Help please!

1 Reply

I've had this problem for years.  It's because their circular references check is faulty and among probably other miscues, like in your situation, it includes repetition of correct formulas in adjacent cells. 

 

Does anyone know when MS plan to fix this adjacent cell misread problem?