Sunday, July 14, 2013

How to Unshare a Workbook


How to Unshare a Workbook in Microsoft Excel 2003
1. Open the Microsoft Excel 2003 application on your computer and then click the “File” option from the top toolbar menu. Click on the “Open” option.
2. Locate the Excel 2003 file that has the workbook you want to stop sharing. Click on the file and then click the “Open” button.
3. Click the “Tools” option from the top toolbar menu and then click the “Share Workbook” option.
4. Click the “Editing” tab from the “Share Workbook” dialog box. Click on the box next to the “Allow changes by more than one user at the same time” option so that it is deselected.
5. Click the “Yes” button to stop sharing the workbook. Click the “File” option and then click the “Save” option to save all of your changes.
How to Unshare a Workbook in Microsoft Excel 2007
6. Open the Microsoft Excel 2007 application on your computer. Click the “Microsoft Office” button and then click the “Open” option.
7. Locate the Excel 2007 file that contains the workbook you want to stop sharing. Select the file and then click the “Open” button.
8. Click the “Review” tab and then click on the “Share Workbook” option from the “Changes” group.
9. Click the “Editing” tab from the “Share Workbook” dialog box. Click on the box next to the “Allow changes by more than one user at the same time” field so that it is deselected.
10. Click the “OK” button and the workbook will no longer be shared. Click the “Microsoft Office” button and then click the “Save” option to save your changes.

Blogger news