Summary Sheet Monitored Live

[Sharpie King]

I have a service call dispatch log that I use in Excell 2003. The file is
protected and shared as view only on a network. I need to monitor the summary
sheet (calls not cleared), of the call status, using one of our network
stations, with the display being updated live, without having to enter
refresh. The display will be a large screen mounted on a wall for supervisors
to monitor the call status. Is this possible with Excel? or do I need to look
for a solution using Access? What would be my best course of action to begin
finding the direction I need, to accompolish this task with either Excel or
Access? I understand detailed information will be found through Access'
portion of this forum if Access is my best solution. I am beginning with
Excel since that is what format the current log is in. Any assistance is much
appreciated.

 

[Kevin B]

I don't know if this will be of much help, however, press Alt+F11 to open the
VBE and in the project window click on the Workbook object of your shared
workbook. (If the Project window is not open press Ctrl + R)

In the properties window (press F4 if Properties window is not visible) of
ThisWorkbook, set the AutoUpdateFrequency to any value between 5 and 1440 to
set the update interval, where 5 indicates 5minutes between updates. 5 is
the minimum acceptable value for the autoupdate.