Hi all,

I am trying to pull off the following thing. Have a Shared workbook that runs on three pc. Each of them can modify and save it for the others to see. Now, Excel updates to the most recent saved version whenever each sheet is saved. That is either by doing it manually or automatically (minimum every 5 mins). I am trying to figure it out how to do the following:

WHENEVER ANY OF THE SHEET SAVES NEW INFORMATION THE OTHERS SAVE AS WELL SO THAT CAN GET IT

It is something more or less similar to a Real Time Update - I was thinking to use RTD but the new info comes from calculation within the sheet and not from an external source. I am thinking is maybe something that should run in the background. I cant set up a macro that continously saves as that clashes with the other application that runs together with the Shared book. Basically i am trying to have the other books "catch up" immediately whenever anyone saves - mayba spacing a minimum amount of time otherwise this thing will get into some kind of loop i fear

Any ideas anyone??


Many thanks

BC