How to Unshare a Workbook

By Greg Lindberg

Microsoft Office Excel allows users to store data into multiple workbooks within a single document file. The workbooks that are created can be shared with multiple users at any time, which allows user access to the data in the workbooks. The owner of the workbook can stop the workbook from being shared by using the "Share Workbook" option available in both Excel 2003 and 2007. Before you remove sharing access you must make sure that all other users have saved and closed out of their shared workbooks.

How to Unshare a Workbook in Microsoft Excel 2003

Step 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.

Step 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.

Step 3

Click the “Tools” option from the top toolbar menu and then click the “Share Workbook” option.

Step 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.

Step 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

Step 1

Open the Microsoft Excel 2007 application on your computer. Click the “Microsoft Office” button and then click the “Open” option.

Step 2

Locate the Excel 2007 file that contains the workbook you want to stop sharing. Select the file and then click the “Open” button.

Step 3

Click the “Review” tab and then click on the “Share Workbook” option from the “Changes” group.

Step 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” field so that it is deselected.

Step 5

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.