From the course: Excel 2013 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Sharing workbooks - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.