Sharing workbooks

Hi Katie

Thanks for your question.

Yes absolutely, saving your document to the cloud is the best way to allow several users to work collaboratively on the same piece of work.

An easy way to do this is to save it to your personal OneDrive folder, then share access to it with the other contributors.

When you click the Share button it will give you the option to save to OneDrive (you may need to sign in to your Microsoft account). Once you've saved the document a box will pop up offering to send the link. Here you should first decide what access you're giving people to the file (edit, view etc) and how long they can access it for. You can then share either by typing in email addresses and a message directly, or by clicking copy link and sending it in another format.

When you share a file in this way, any changes made and saved by other users will automatically update in the original document. This makes your collaborative work much more efficient, because you can avoid sending different versions of documents back and forward.

Let me know if you have any further questions.

Kind Regards,
Sarah
MS Office Trainer