Use of UNC
 

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 of UNC
 

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\

Use of UNC
 

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\