Hi guys!

Here is my problem -

I have a source file that is updated often throughout the day (manually) with production data. I have created a destination workbook that simply takes the source file and rearranges the entries for aesthetic reasons (the values in the destination workbook are a serious of 'Cell Xdest. = contents of Cell Ysource'). The destination workbook is intended to always be open and act as a 'real time' summary when the source file is changed.

The problem I'm having is the destination file (while open) doesn't update when the source is updated. IF the two files are open on the same machine, no problem, but when the two files are on different machines the update to the destination only occurs if it's closed and re-opened.


Is there a way for me to properly link to the source file to allow the destination file to be automatically updated? A less ideal solution I guess would be to create a Macro (assigned to a button) that can be selected to update the links manually. - but what would that code look like?

Any help would be GREATLY appretiated.

Thanks!