I have two workbooks that I want open, each in a separate instance of Excel
2007. One workbooks is the "Master.xslx". The other is the
"Destination.xslx". I'm using formulas to gather data from the Master and
pulling into the Destination.

This is simplified, but my formulas in Destination look something like this:
=SUM('C:\Documents and Settings\user\My Documents\[Master.xlsx]Sheet1'!B1:B2)

While I'm editing Master, I want Destination to update. The only way I've
found to do this is using the Edit Links dialog box in Destination and
manually updating the links. I can't seem to make Destination update
automatically. I want Destination to automatically update every minute if
possible.

Does anyone know how to do this? I've tried setting up .odc to no avail. I
would love for clicking the Refresh button to work, but it doesn't seem that
I've found a way for that to happen yet.