What I am trying to do is have an Excel 2003 spreadsheet (A) where data gets entered, and a summary Excel spreadsheet (B) where I have graphs set up to take the linked data from A and graph it. All of this so that a supervisor can log onto the company network and open spreadsheet B and see graphs of the various important test results.
What I see happening is that since spreadsheet B stays open in order to be constantly updated by links to spreadsheet A -- that a supervisor when they log on to the company network from home only sees the last saved version of spreadsheet B and not the realtime version. The only way that this works is if the supervisor ALSO loads the other spreadsheet which totally defeats the purpose!
I'm am guessing that I should come up with a way to VBA code spreadsheet A to automatically make spreadsheet B save, so that B would be current whenever it got opened.
*The overall goal is to make certain values quickly available to offsite supervisors. Maybe I will find out if this can be done with email or text message while not using Outlook... but for now the above plan would suffice.
Any kind individuals have the solution?
Thanx!
What I see happening is that since spreadsheet B stays open in order to be constantly updated by links to spreadsheet A -- that a supervisor when they log on to the company network from home only sees the last saved version of spreadsheet B and not the realtime version. The only way that this works is if the supervisor ALSO loads the other spreadsheet which totally defeats the purpose!
I'm am guessing that I should come up with a way to VBA code spreadsheet A to automatically make spreadsheet B save, so that B would be current whenever it got opened.
*The overall goal is to make certain values quickly available to offsite supervisors. Maybe I will find out if this can be done with email or text message while not using Outlook... but for now the above plan would suffice.
Any kind individuals have the solution?
Thanx!
