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 in
workbook A and update in real time (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

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