From the course: Excel 2016 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Sharing workbooks

Sharing workbooks

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Sharing workbooks

“

- We're looking at a worksheet called "Vendor Sales." It's in the workbook 11 - workbook before sharing. Imagine different people access this file at different times. They open it, they add some information to it. And over time, what's happened is, there are so many different people who make changes to this, that at different times, someone tries to open this, and sees the indication that it's read-only because somebody else has it open. What we'd like to be able to do is to allow different users to open this at the same time, and be able to make changes to it. And I think you can see some potential problems there already. But still, the idea of allowing different people to have the same file open at the same time, and be making changes to it, is going to make sense in certain scenarios like the one I just described. This feature is called "Sharing," and on the review tab you'll see an option called "Share Workbook." And as we slide over that, we see the description "Share your…

Contents