We have a pretty unique situation at work. We have order takers who take orders and each individual references the same shared read-only excel document on a network storage drive. This excel document contains multiple sheets that has prices and other formulas that contribute to correct pricing for a customer's order. Along with those sales prices there are sheets that contain reference information, etc.
Certain places where the orders are being filled only have so many resources available. We would like to include in this shared, read-only spreadsheet information that will automatically update without having each user close and re-open the excel document.
It is my understanding that you can specify a data source (such as a database or a web document, etc) to pull some of this information directly into the excel document every few minutes. I have thought about creating a local web page to feed data into the main excel spreadsheet which is on a network drive (If I do it this way I have no idea what programming language to use).
We are running Office 2003 (still) but have Office 2007 on some computers. Additionally most of the computers in the office are Windows XP and we are close to migrating everyone to Windows 7 64-bit machines.
- Automatically push information into a shared, read-only excel document.
- The excel document is saved as a 97-2003 .xls file.
- The computers are all currently running Windows XP, upgrade coming in a few months.
What is the best way to set this up? Any suggestions without having our office re-invent the wheel?