>From Excel help: If you want to get automatic updates of the other users' changes periodically, with or without saving, click Share Workbook on the Tools menu, click the Advanced tab, and under Update changes, click the options you want.
or... another way round it may be to set the Update Changes option to "When files is Saved" Then, install the autosave add in, and set that to automatically save every minute or so... or... I heard MS has an auto save add-in but haven't looked for it. Does that do the trick for you? On Tue, Nov 3, 2009 at 12:04 PM, C. Hatton Humphrey <chumph...@gmail.com> wrote: > > I figure with the expanse of knowledge on this list somebody's got to > have an answer to this question: > > We track one of our main routines using a shared excel spreadsheet > that is updated by various employees. It is set up at the moment so > that changes appear whenever an employee saves the file. > > I wish I could say that this is being moved to a web interface but > there are other things taking precedence. In the meantime, the > request has been made that we have a PC set up that displays this file > at all times, constantly updated. > > Knowing nothing about Excel, I'm wondering if there is a macro I could > embed in the spreadsheet that would cause it to automatically reload > itself every minute or so? > > Thanks! > Hatton > > No trees were killed in the sending of this message, but a large > number of electrons were terribly inconvenience > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:306952 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
