ChatterBank5 mins ago
Excel Workbook On A Web Server
1 Answers
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
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
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by Bushwhacker. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Only 1 answer
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.