relative file path location

[Andy]

Hi all,

I am using Excel XP on a network at my work place, my
problem is that if I have two excel workbooks, one of
which links to the other.

Now if I have the both files open the link "file path" is
straight forward, however if one files is shut the link
obviously contains the full file path location.

open = file name / cell
closed = file path / file name / cell

My problem is that I would like to email both of the files
but I understand that if this is outside of my company the
file location link will no longer work, is there a way to
create a "relative file path location" providing both
files are in the same folder.

Many thanks

Andy

 

[Jim Rech]

If the files are opened from the same folder there should not be a problem.
If there were a problem however the user would just have to use Edit, Links
to correct the link.

 

[Andy]

Thanks Jim,

if thet where in a differant location, is there a way
around this issue.

I understood that there was relative file path location pth
that went something like this

\\Filename\c:drive etc etc

 

[Jim Rech]

if thet where in a differant location, is there a way around this issue.

The files can be in "different locations" only if their relation to each
other is unchanged. For example if the data file is in a folder named
"source" under the folder the dependent file (the file with the linking
formula) is in, then Excel can find the linked file. Otherwise it cannot.

In other words, the relative path must be unchanged.

If it is changed, Excel will prompt for the location of the source file.
There is no way around this as Excel will not guess.