Hi, I have a question about linking and updating cells referencing
another workbook on another machine on a home network.
I have a workbook opened on machine A on my home network. On a second
machine B located on the same network, I have a second workbook opened
and on this workbook B I want a range of cells to reference a range of
cells in workbook A and update in real time that destination range on
workbook B (if it is possible in this case).
I have formatted the destination each destination cell on machine B
using the formula
='\\SourceMachineA\directory:\[WorkbookA.xls]Sheet1'!A25
When I enter the formula I get prompted with an "Update values" dialog
box and after pointing it to the source workbook, the value in the cell
gets updated correctly; so I know that the formula is formatted
correctly insofar as it points to the right location. However, this is
the only time when I can get the value to update
I have also tried by mapping the source drive on the destination
machine and using that in the formulas, but it doesn't work any better.
Is it possible to do what I am trying to do (directly reference a cell
from another workbook on a second machine located on the local network)
and if yes, what am I doing wrong? If it is impossible, what are the
alternatives to accomplish the task?
All help and suggestions would be much appreciated. Thanks in advance,
Joe
Bookmarks