Finding the Cell that was Referred to another excel Workbook/Sheet

I referred a cell by accident to another workbook/sheet that every time I try to send it to someone else it just wont open for them because it says reference not found.

Is there any easy way to finding the cell I referred. It is a lot of cells to go through.

I know how to break links but that's not the same thing.