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.

It happens
- when a cell/ row/ column are deleted.
- when a cell/ row/ column is cut and copied in to some other location

stop using the above things and use copy & paste instead of cut.
instead of deleting entire row/ cell/ column, try deleting contents of it.


*** please do rate ***

"Distressed" wrote:

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.

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.