I'm wondering if it's possible to link workbook cells from one Excel doc. to another over a network dynamically?
IE - A1 on Computer 1 is linked to A1 on Computer 2 and updates dynamically when changed.
Firstly - how would one go about this?
Secondly - what would be the time loss in doing so (i.e. the time lost to transmission and updating of the info?)
Thanks for any good ideas.
Ethan Altaratz
IE - A1 on Computer 1 is linked to A1 on Computer 2 and updates dynamically when changed.
Firstly - how would one go about this?
Secondly - what would be the time loss in doing so (i.e. the time lost to transmission and updating of the info?)
Thanks for any good ideas.
Ethan Altaratz