Links - Use Network Address???

  • Thread starter Thread starter Karl Burrows
  • Start date Start date
K

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!!
 
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.)
 
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.)
 
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???)
 
Back
Top