Excel Linked Cell Reference is lost

We have a problem with linked cells. We have a main spreadsheet which links
> to other spreadsheets, the problem is that occassionally the linked cell
> refrence is lost and the cells are replace by #ref.
>
> Can anyone help please.