1,105,225 Community Members

Roaming Self-Updating Excel File

Member Avatar
Radio2006
Light Poster
34 posts since Dec 2006
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
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.

Member Avatar
BigPaw
Master Poster
736 posts since Oct 2012
Reputation Points: 17 [?]
Q&As Helped to Solve: 42 [?]
Skill Endorsements: 5 [?]
 
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

Member Avatar
JorgeM
IT Addict
6,379 posts since Dec 2011
Reputation Points: 567 [?]
Q&As Helped to Solve: 953 [?]
Skill Endorsements: 172 [?]
Moderator
Featured
Sponsor
 
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.

Member Avatar
Radio2006
Light Poster
34 posts since Dec 2006
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
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 three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: