I am getting an error in the predecessor column.

While adding a predecessor in the cell, it is showing following error.

(#REF)

And when I am trying to click on the pencil icon it is showing circular dependency. How to figure out and fix the issue?

Answers

  • John_Foster
    John_Foster ✭✭✭✭✭✭

    Hi @ayush,

    If you click the pencil it should pop up the dependency window showing the row number it is linked to, this will then allow you to track back through the various dependencies to find why this is circular. Of course, depending on the size of your sheet this may take some time to find.

    John