From the course: Excel 2010 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 a workbook - Microsoft Excel Tutorial
From the course: Excel 2010 Essential Training
Sharing a workbook
In a previous movie, we looked at some of the options for protecting workbooks and setting permissions. In this movie, we'll make use of that in sharing a workbook with other users. What if you're working on this workbook and you want other people to be able to modify the same workbook at the same time? Well, click the Review tab and choose Share Workbook. And this dialog box that comes up says do you want to allow more than one user to share at the same time? And it should show that you have it open. Click the checkbox. Click OK. It's going to save the workbook. Click OK to confirm. Now, not much has changed, except you can see up here that the workbook is now in Shared Mode. So, if I were using this right now with other people in the company modifying this workbook, I might see some of the information changing. Well, when we're done with that, when we want to take control back for ourselves and disallow other people from making changes, just click on this Share Workbook again…
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.