Cells are changing to REF even though it still has all of its precedence tracked as well.

Occasional Visitor

I have made a binary workbook that is linked to a table to lookup data. within the table it has cells that is having refence errors even though it isn't linked to a cell with refence error, nor does any of the cells have a refence error within itself. All calculations are automatic and the error doesn't show until I hit enter within the column/cell, that will then become a error. When I hit enter I have not edited any contents it just happens. What could be the cause?

0 Replies