Links - Use Network Address???

[Karl Burrows]

I am trying to keep linked files active in a 2000/XP workbook regardless how
they are accessed (network mapped drive, VPN/remote access, etc.). I am
working on some programming thanks to the help on the newsgroups, but was
wondering if using the UNC path for the linked file will work? Can I just
change the link reference in the formulas to \\server\worksheetpath?

Thanks!!

 

[Dave Peterson]

I use the UNC path and it works for me. Try it with a few and see if you have
any trouble.

But I don't recall anyone accessing the files remotely, though. (But my
uneducated guess is that it shouldn't matter--won't that remote user be on the
network?? You'll probably want to try that, too.)

 

[Karl Burrows]

I tried a test and it kept prompting me for the file. Is there a method you
use? I tried \\server\folder\file.xls.

I use the UNC path and it works for me. Try it with a few and see if you
have
any trouble.

But I don't recall anyone accessing the files remotely, though. (But my
uneducated guess is that it shouldn't matter--won't that remote user be on
the
network?? You'll probably want to try that, too.)

 

[Dave Peterson]

for hyperlinks, I just inserted a hyperlink an pointed it at:
\\server\sharename\folder\filename.xls

For formulas with links, I opened the workbook and pointed at the cell.
Then closed the workbook.
And the link was built for me by excel.

(maybe you missed the sharename in your test???)