Forum Discussion
excel editng
hi, im trying to figure out how to share and edit some excel sheets through email, what im wanting is to be able to send a spreadsheet to multiple people at the same time, so for example I send the sheet in an email to person 1 and person 2 at the same time, person 1 then makes an edit and overwrites the original that is saved on the network, person 2 then opens his email and it is now the edited version of the sheet I sent. is this even possible at all?
4 Replies
- Ed HansberrySteel Contributor
whywontthiswork365 THis will not work with network files on your system. You can do this with files stored online in OneDrive, OneDrive for Business, or Sharepoint online (All part of Office 365.) See this article to get started with all of that if you can store the file in the cloud.
- whywontthiswork365Copper Contributor
Ed Hansberry I was afraid of that, seems like it should be an easy thing to do, was wanting to avoid using onedrive because its more steps and takes longer, thanks for your answer
- Ed HansberrySteel Contributor
The reason is Microsoft servers are doing some of the actual work, not the desktop clients, to coordinate the changes, and it is also securely allowing outsiders you designate to access the file. I cannot imagine the hassle it would be for an IT team to allow outsiders to access specific files on the network (non-employees, short of setting up a VPN then setting very specific permissions for files as opposed to entire shares), and even then, the server component only exists in the cloud services of Office 365/OneDrive.