JustOneQuestion
New Member
- Joined
- Jul 5, 2016
- Messages
- 19
Is it possible to create a excel sheet and then send it via email in such a way that allows multiple users to access it, but updates to every sheet? I am not sure if that is clear. But I want to have multiple people be able to open the sheet on different computers/locations/times and be able to edit it, but have the edits update to everyone else without having to save the file, and then re-email it to each person and have a large number of different copies.
Really I am shooting for the Excel version of Google Sheets. Where it updates all the time and anyone can be working on it. I know using Google Sheets would be easier, but for a number of reasons, I am trying to make it work with Excel.
I have tried to share the workbook with others, but the edits will not update in any place but the current users file. If I wanted the new edits to get to everyone, I would have to email the file again. Here is how I have saved the sheet and shared it:
Share Workbook -> Update Workbook every 5 minutes -> save -> email -> that person then opens the sheet and makes changes but the changes do not affect my sheet.
I am using Excel 2013, and so are they.
Really I am shooting for the Excel version of Google Sheets. Where it updates all the time and anyone can be working on it. I know using Google Sheets would be easier, but for a number of reasons, I am trying to make it work with Excel.
I have tried to share the workbook with others, but the edits will not update in any place but the current users file. If I wanted the new edits to get to everyone, I would have to email the file again. Here is how I have saved the sheet and shared it:
Share Workbook -> Update Workbook every 5 minutes -> save -> email -> that person then opens the sheet and makes changes but the changes do not affect my sheet.
I am using Excel 2013, and so are they.