Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

sharing workbooks

ResolvedVersion 2016

Katie has attended:
PowerPoint Intermediate Advanced course
Excel Advanced course

Sharing workbooks

Hi,

I would like to know how best to allow multiple people to work in the same file at the same time? When I click share in top right it asks me to save to cloud - is this usually the only option for making this happen?

Thanks :)

RE: 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

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.14 secs.