Excel - Turning Off Sharing

To turn off sharing and come up with your final version of the workbook.

You can turn off sharing by following these steps:

1. Display the Review tab of the ribbon.
2. Click the Share Workbook tool, in the Changes group. Excel displays the Share Workbook dialog box.
3. Clear the Allow Changes check box.
4. Click on OK.

When you turn off sharing and click on the OK button, Excel displays a warning that what you are doing may have consequences for other users. Provided there are no other users accessing the workbook, you should go ahead and click on Yes. If there are other users (shown back in the Share Workbook dialog box), you may want to ask them to save their changes and close the workbook before proceeding.

Microsoft Accredited IT Training Provider

Microsoft Certified Training Materials

IT Training Courses delivered by Microsoft Accredited Facilitators

Microsoft MOS Test Centre London