Automatically Update a Shared Workbook

[dreicer_Jarr]

Situation: We have an Excel file (master file) on a network that needs to be updated by three different users; in three different locations; at three different PCs. The maste file updates automatically every 10 seconds based on some code in the master file. However, the shared workbook function in Excel (tools/share workbook) limits the shared automatic updates to every five minutes (at the least). (This is seen by going to tools/share workbook/advanced and then "update changes" and then "automatically every...".)

Problem: The master files needs to be updated with any changes as soon as they happen (or within, say 30 seconds). The master file does this, but the shared function does not seem to allow it (meaning the updates from the "updating" computers would not refresh but every five min).

Let me know if this makes sense or you will require additional information to lend a hand. As always, thanks for your Excel brilliance. I am coming a long thanks to you!

D