Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question

2 Answers 2

up vote 3 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.

share|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

Try uploading the file to Google Docs. It will save automatically and so the updates are available seconds after you make them. It supports multiple users, and the only difference would be that all users have to be online to access and update it.

share|improve this answer
    
This question has already a best answer. You are also not fixing the problem, since you are just promoting Google Docs above Excel. The actual problem is to handle data between two different sheets. –  Nick van Tilborg Mar 27 '13 at 9:28

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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