Excel 2003 losing Linked Cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Distressed - 23 Aug 2006 15:44 GMT

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.

Reply to this Message

Naveen - 24 Aug 2006 07:28 GMT

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 ***

> 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.

Reply to this Message

Andy Wiggins - 28 Aug 2006 21:49 GMT

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

Signature

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

> 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.

Reply to this Message