relative links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BartvD - 11 Sep 2003 11:33 GMT

Hi list,

Is there a way to tell Excel not to change relative link references between
workbooks (using ..\ or .\ ) into abolute ones? I would like to copy a set
of workbooks to another directory (eg. to have different versions of this
set). I know I can set the links through edit > links, but I'm looking to
have this done automatically through relative links.

It is possible with the INDIRECT() function, but I want a direct solution
without the need of opening all workbooks and have all links in seperate
cells.

Thanks,
Bart

Reply to this Message

Bill Manville - 11 Sep 2003 13:33 GMT

> Is there a way to tell Excel not to change relative link references between
> workbooks (using ..\ or .\ ) into abolute ones? I would like to copy a set
> of workbooks to another directory (eg. to have different versions of this
> set). I know I can set the links through edit > links, but I'm looking to
> have this done automatically through relative links.

Links between workbooks that are in the same directory are treated as relative
links. If, for example, 2 users see the same files on a network server via
different drive letters and paths the links between them will work for both
users.

If you copy the files using Windows Explorer (etc) from one directory to
another the links will continue to work.

The same goes for links to files in a sub-directory of the directory
containing the workbook which contains the links.

If the links are not to the same directory (or a subdirectory thereof) then
you are out of luck. You could write a macro to repair the links after moving
the set, however.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message