J
Jeff Donahue
When I create a spreadsheet that links to another
spreadsheet, we seem to be having a problem with our
links.
What we want to do is to create the links so that it has
an "absolute" path so that no matter what direction or
level we open the file from, the link path does not
change. We have people that open the files from various
directions (ie - through a mapped drive, and through My
Network Places path) and from various levels (we have set
up security access so that some people can only get into
certain levels of the path and not others).
What we have been finding is that if someone opens a
linked file from one diretion (say, a mapped drive) and
then saves the files. Then another person opens from My
Network Places and saves the files, that when we go back
into the file from the mapped drive level, the links seem
to have broken and become relative paths.
Can anyone help me on this one?
Thanks in advance
Jeff Donahue
spreadsheet, we seem to be having a problem with our
links.
What we want to do is to create the links so that it has
an "absolute" path so that no matter what direction or
level we open the file from, the link path does not
change. We have people that open the files from various
directions (ie - through a mapped drive, and through My
Network Places path) and from various levels (we have set
up security access so that some people can only get into
certain levels of the path and not others).
What we have been finding is that if someone opens a
linked file from one diretion (say, a mapped drive) and
then saves the files. Then another person opens from My
Network Places and saves the files, that when we go back
into the file from the mapped drive level, the links seem
to have broken and become relative paths.
Can anyone help me on this one?
Thanks in advance
Jeff Donahue