#REF in Predecessors

Veronica de Capileira

What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window?  I can't figure out what to do with them.  I searched the Help Center and they say that #REF means "The formula references a cell which does not exist, possibly due to a row/column deletion." but this is not in a formula so I can't delete the formula and fix this.  Please help.

Mike Wilday

Can you share the formula you are using to get the #REF error? 

Also, circular dependency means you are including that same row in the dependency row. If your row is row 10, you can't make row 10 dependent on row10. So make sure you aren't including the row you are selecting in your circular dependency.

 

Veronica de Capileira

Hi Mike,

I do not have a formula in this row since it's a Predecessor column.  When I open it up, I see this Circular Dependency warning.  I will check out my rows and see if they are dependent on each other like you're describing.

 

Veronica

Jayam Nagesh1

Hi, 

Check the column properties once. you may get the result.