I have two excel workbook The first one located in one computer (i.e. "\192.168.7.1\Shared\book1.xls") The second one in another computer (i.e. "\192.168.7.2\Shared\book2.xls")
With both spreadsheet opened in the relative computer, I want to link the
Book1!A1 cell on the second one, then any time the Book1!A1 cell change the book2 refresh the values...
Is that possible?