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?
How it could take more steps with OneDrive? Back to your example, you sent email to persons 1 and 2 with attachment on the file as link, Person 1 click on attachment (that is link), edit and notify person 2 he may continue. Or the could work in co-authoring mode if person 2 doesn't need to wait data from person 1. As a bonus you have automatic version control and always may check who, when and what edited.
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.