When the link is "lost", how do you get it back? Do you have to relink to
the source workbook?

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"Distressed" wrote in message
...
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.