Automatic Link Updates

Hi,

I have created 2 workbooks, one is a master, and one is a template that there will be many iterations of. Both share information with each other using linked cells. If employee names change on the master it updates the templates, if the template hours change, it updates on the master. If I have both sheets opened on my own computer at the same time, the links will automatically update in real time without me having to manually check the sources and update them. If the workbooks are open on different computers, it will only update on opening of that workbook. I have written a VBA script that, with one button click, updates all links in the workbook but only if the linked workbook was changed, then saved. This is okay however I really would like this to update in real time when the workbooks are open on different computers, just as if I was working on it in real time on my computer. Is there a way to do this? I have done some research and have not found a solid answer.

Thank you for your time!

Well I haven't looked into shared books yet. Basically one person will be managing the master and each Project Manager will be managing a few of the template sheets. The master schedule, I would like to update when a PM makes a change. After doing some research into it, it seems macros do not work on a shared workbook. Is this true? I tried to share it and play a bit with it but no luck. This is a macro heavy workbook so this is not an option. Not sure if there is a work around yet.

Any suggestions?

Thanks!

Yeah I read a bit since my last post. Some of the macros do work however some do not. And you can't trouble shoot it easily since it is not editable haha. I'm kind of at a loss why it would work when WS is not enabled then when it is it just breaks. Correct me if I'm wrong, but this would still not be 100% immediate correct? Based on the settings, I have update every 5 mins minimum or at every save. This is kind of similar to the current situation I believe. I think a database might be a better option in general but not for our application unfortunately.