Shared Workbook - Saving problem
 

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


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=553955