Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary Sheet Monitored Live
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Summary Sheet Monitored Live
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. -- Kevin Backmann "Sharpie King" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
summary sheet | Excel Discussion (Misc queries) | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Summary Sheet | Excel Worksheet Functions | |||
Relative Sheet Reference (Summary Sheet) | Excel Discussion (Misc queries) | |||
Summary sheet | New Users to Excel |