A
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
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