up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
80% accept rate
feedback

1 Answer

up vote 2 down vote accepted

If you really want the functionality of changes updating quickly, then you will have to use a version of office that supports collaboration this way (like Excel Web Apps) and then use different spreadsheets or something similar to do the references.

If you want to skip the real-time (or anything like it time) update, you can use: ='\192.168.7.1\Shared\[book1.xls]Book1'!A1
to access a cell in the other document. Note that this data will only get loaded when the files opens.

In short, excel was not meant to do what you want it to do, but these workarounds might help.

link|improve this answer
Thank you I used the link like the one you wrote, but I didn't know about the fact that this link won't update... do you think it works if I use a VBA macro for the timing? – Marcx Dec 29 '11 at 9:40
No, the timing cannot be solved using excel. – soandos Dec 29 '11 at 20:26
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.