View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.links
Naveen Naveen is offline
external usenet poster
 
Posts: 100
Default Excel 2003 losing Linked Cells

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.