link to cell across lan

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

there is a computer running a file on my network.

the file is \\laptop\documents\trap.xls
is there a way to create a link to sheet1!A1 in that file
from an excel file running in my computer at another
location on the network??

a hyperlink that will run the file on my computer is
\\Laptop\documents\trap.xls. but i only want to have an
active link to the cell fo the file running on the other
computer.

How??
 
Hi Paul,
the file is \\laptop\documents\trap.xls
is there a way to create a link to sheet1!A1 in that file
from an excel file running in my computer at another
location on the network??
Click to expand...

Do you mean such that whenever someone types something into A1, the
change automatically appears in your sheet? If so, then no, there's
nothing built in to Excel to achieve that. However, you might be able
to get it working using NetDDE, as described in:
http://support.microsoft.com/kb/q128491/

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Countif across sheets? 5
using dhRichClient3 across a LAN 2
Determine a computer's fingerprint? 8
Upload Data from Sheet1 on Local Machine to Sheet1 on LAN 2
Code to change part of a formula across worksheets 4
Macro to generate powerpoint slides 43
Chkdsk "replacing invalid security id with default id" windows xp 4
Help needed - Strange hyperlink problem 5

Back
Top