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.