Excel Workbook On A Web Server

[Bushwhacker]

I regularly email a lot of data out worldwide for review.

Currently, I send out multiple Excel workbooks to multiple users who then review their data. Along with reviewing their data, these users also make (and save) changes to the data. The workbooks are then emailed back to me and I collate all the data back into one master file. (NOTE : The data in each workbook shares exactly the same format, it is just the data values that are different).

I have a vague notion that I would like to locate just the one master Excel workbook on a web server, with each user being able to access this file, review their part of the data and make changes if necessary (which would all be saved). I would like to put the file onto a server, notify the users of it being there and then go back to the server a few days later and pick up the reviewed file (with all changes that had been made to the workbook having been saved).

Is this possible ?? What are the pitfalls ?? Is there a better way of addressing this etc. etc.

All advice greatly appreciated.

Thanks in advance

BW

[MVP]

Sounds like you might get some mileage from shared folders in "Live Mesh".

https://www.mesh.com/Welcome/sharemesh.aspx