Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
link to cell across lan
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?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Paste using cell link option Half works | Excel Worksheet Functions | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Can Excel 2003 cell link carry with it the source cell format? | Excel Discussion (Misc queries) | |||
Cell only shows link in text, not contents of reference cell | New Users to Excel |