Rows have (mysteriously) deleted

Michal Holtz

Hi,

few rows were disappeared from a sheet. When I look in the activity log, I see that this was done on the rows:

Row: "Druva" Duration: =CALCDURATION([Original Start Date]68, [Due Date]68) = 0 to: =CALCDURATION(#REF, #REF) = 0

 

Any idea what happened?

 

Mike Wilday

It looks like your formula changed. Perhaps your rows were deleted or cut. #Ref is an error message that communicates that the references that were there no longer exist. Can you confirm that row 68 still exists? 

Michal Holtz

No, this line was deleted.

But now I understand what does it mean.

Something has been done but the activity doesn't say exactly what.

Thanks

 

Paul Newcome

Were the columns deleted and then re-added with the same name? That would cause the same error as well.