Hello,

I am using two source workbooks to provide data for one viewing workbook just with linked references. The viewing workbook has some code in it to update values every two minutes, and the viewing workbook is constantly open on a presentation machine. The workbooks are kept on a server and the viewing workbook is not open on the same machine as the source workbooks.

The problem I've seen a couple of times is that on the Data tab, in edit links, the Locations of the links are changing slightly. The change looks like this "Location: \\server\tech\ads changes to Location: \\server\tech\tech\ads". So for some reason the Location name is adding a folder twice, and that makes the link no longer work. It's happened twice in two weeks, and I'm not aware of any other event happening at the same time that might be related.

Any ideas as to the cause and solution to this? Much appreciated, thanks.