From the course: Excel 2013 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 - Microsoft Excel Tutorial

From the course: Excel 2013 Essential Training

Start my 1-month free trial

Sharing workbooks

“

We're looking at the file called 11-Workbook before Sharing. It's got a single sheet in it called Vendor Sales and let's imagine that one person has been updating this from time to time and then others get involved too and they make changes to it. Eventually the need might arise that these different people who do the updating might need to have the file open at the same time. A file can be open by different users, but we also want to allow them to be able to make changes at the same time and that's a special status. Excel refers to this capability as sharing the file and that might sound as if we're just allowing others to open the file, but it's more than that, it means simultaneous sharing and making changes. So to put a worksheet in that kind of status we go to the REVIEW tab and Share Workbook. Share your workbook so that others can work on it at the same time. Note the information here, workbooks containing tables can't be shared and by the way, you should check the help system…

Contents