We have been using cloud based applications such as Dropbox, OneDrive, and Google Drive to share files across several users. They each have desktop applications that will allow the files to be synchronized in a certain folder in the hard drive. But our issue is that the consistency of the synchronization is terrible. It is quite often that the files in the web application of Dropbox, OneDrive, and Google Drive are updated, but in the desktop application of the user, it will fail to synchronize.
Our primary purpose for this is for our Excel files that require data of all the users to be updated. Because if only 5 out of 10 users have updated files when the Excel file is analyzed, then the data will be distorted and very bad.
If cloud based applications are no good due to high failure rates, we also considered using Google Sheets and create a data connection to the Excel file, but we cannot seem to find the option to make a real time link between Google Sheet and Excel. We cannot use Google Sheets standalone because it does not have Visual Basic for Applications (VBA) capability and the automation advantage will be lost.