Excel 2003 losing Linked Cells Distressed 23.08.2006 14:44:02 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.

RE: Excel 2003 losing Linked Cells Naveen 24.08.2006 06:28:01 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: [Quoted Text] > 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. > > >

Re: Excel 2003 losing Linked Cells "Andy Wiggins" <contact me via my website at www.BygSoftware.com> 28.08.2006 20:49:32 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" <Distressed[ at ]discussions.microsoft.com> wrote in message news:3AF6734D-FD36-4B19-B86A-D0768347B1A5[ at ]microsoft.com... [Quoted Text] > 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. > > >