View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stephen Bullen[_4_] Stephen Bullen[_4_] is offline
external usenet poster
 
Posts: 205
Default link to cell across lan

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??


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