1.11M Members

Roaming Self-Updating Excel File

 
0
 

Hello to all,

I am working on a spreadsheet/database for my company to track our service calls for the equipment we sell. There are a total of three of us that travel to different locations. I have helped create a database that allows a user to enter information after completeing a service call. However, the interface is awesome and the company wants to use it as a service report as well. Problem is that service reports travel with the technician while the database is hosted on the server.

Long story short, is there a way that I can make this file available locally to the technician in the field by making it an offline file and then when they return and connect to the server back at the office, the server copy and the local technician copy sync to update changes? Also, a VPN is out of the question...for now.

OS: Windows 7 Professional SP1
Program: Microsoft Office Excel 2007

If more information is needed, just let me know and thanks in advance.

 
0
 

There the basic route of Object Linking and Embedding. (OLE)

Are the likes of Google Drive, Dropbox, etc, ruled out?

Or, are you looking for something like scripting

 
0
 

You can use Google Drive, Sheets. Provide access to the team members, then anyone of them will be able to update the spreadsheet in real time.

 
0
 

@BigPaw, I will take a look at the OLE and see what it can do. @JorgeMHowever, these guys are not going to want to use a third party to host the file. Although there isn't any classified information contained in the file.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: