Multi-user sharing excel files and automated refresh

Question

Any recommendation on having a shared excel file auto-refresh itself?

We will need 3 users of an excel file on the fileserver. One user will be making changes. Others are read-only, but they must see the change as quickly as possible. Any pointers on how to do this?

Answer 1

In your excel file you need to enable workbook sharing (in 2007 it's the Review Ribbon, Share Workbook). On the advanced tab you can set the "Update changes" to an interval as low as 5 minutes and set it to "Just see other users' changes".

Jesse

Answer 2

Not sure if anyone is still interested in this but there are far more sophisticated tools to do this now.

Checkout https://www.ipushpull.com

Disclaimer (just so I don't get too much hate): I am affiliated with ipushpull