Hi,

Have been trying to figure this out for awhile, and it may just be that it's how Excel works, but I'm using Excel 2010 and have built a file that pulls data from a source file that is located in a centralized location on our server. The file pulling the data has to be used by a lot of different people and is built with the functionality to search and sort the source data as needed, so long as the links to the source file remain unbroken.

Let's say for sake of example that when the original file was built, it pointed to C:\datafiles\work\reporting\source

Now, when different users make copies of the file and move them into their own directories on the server, instead of retaining the original path information for the source file, it tries to look for the data in a modified path.

Let's say Bob is one of the people making a copy, and Bob keeps his work on C:\datafiles\Bob, his copy of the file is trying to find the source file data in C:\datafiles\Bob\work\reporting\source instead of in the original directory. However, if Bob open the file and performs a Save As... in his working directory, the paths remain unchanged. It is only when he makes a copy and pastes it into his work directory that it changes. We have probably 30+ people making their own copy of the original file and depending on how they moved it, none of them work unless they are relinked to the original location.

Is this occurring because of something I'm doing incorrectly in building the original file, or is this just how Excel works? I have tried looking for the answer in a number of places online, but haven't found anything yet. Any help is appreciated - thanks.