Links lost and changed to C drive

[mesteptoe]

I have devised a project management system. Basically there are individual workbooks for each project. Within each workbook there are around 30 separate worksheets to deal with Programme, Finance, Safety Audit, Notes etc. etc. Information from separate cells within each workbook are then linked back to an overall monitoring spreadsheet. The system was originally created on my own hard drive but is now on a network so that it is accessible by individual Project Managers. When saving it to the network the links were recreated to the network location.

Everything had been working fine but something odd happened today. All the links on the overall monitoring spreadsheet suddenly tried to lnk back to my C drive rather than the network location. I have overcome the problem by doing a Search and Replace with file names. Time consuming.

But does anyone know why this problem may have arisen - because, presumably, it could happen again.

Thanks for your help

Graham

 

[GlennUK]

When you originally put the monitoring spreadsheet on the network, did you put it there by doing a Copy from Explorer, maybe? Did you happen to edit the copy that's on your C drive today, and do File/Save As to the network?

 

[mesteptoe]

Hi Glenn

I understand your thinking but I'm pretty certain I didn't as the old file shouldn't be in my Explorer as it hasn't been accessed for a long time - many months.

Graham

 

[GlennUK]

I don't know what you mean by "the old file shouldn't be in my Explorer"? That doesn't make any sense to me at all.

But I must ask again, did you open a copy of the workbook from your C drive, and then save that onto the network?