I have a workbook with many links. I want to have excel always look in the
same directory for my linked files, regardless of relative path. I read the
KB info that says to make it a UNC path instead of a relative path, but don't
see exactly how to do this outside of VBA.

It looks like I would do something like \\AlwaysHere\

Use Edit, Links, pick the link, then Change Source and you should be able to
navigate to the replacement UNC path and file.

--
Jim
"Misssy" wrote in message
...
|I have a workbook with many links. I want to have excel always look in the
| same directory for my linked files, regardless of relative path. I read
the
| KB info that says to make it a UNC path instead of a relative path, but
don't
| see exactly how to do this outside of VBA.
|
| It looks like I would do something like \\AlwaysHere\

I gues I am asking how to make sure it is going to a UNC instead of just
re-linking to another site. This file has many links and Iam trying not to
have to redo the links every time it has to move to a different location.

From Excel's documentation, it sounds like using the UNC vs Mapped drives
would allow that. Am I missing the concept somewhere or trying to do this
the wrong way?

"Jim Rech" wrote:

Use Edit, Links, pick the link, then Change Source and you should be able to
navigate to the replacement UNC path and file.

--
Jim
"Misssy" wrote in message
...
|I have a workbook with many links. I want to have excel always look in the
| same directory for my linked files, regardless of relative path. I read
the
| KB info that says to make it a UNC path instead of a relative path, but
don't
| see exactly how to do this outside of VBA.
|
| It looks like I would do something like \\AlwaysHere\