Quick Answer: How do I Unshare a shared Excel spreadsheet?

If an Excel workbook has been shared in the traditional way, we can easily un-share the workbook using the Excel Ribbon. In the Ribbon, select Review > Protect > Unshare Workbook.

How do I Unshare a shared Excel file?

Turning Off Sharing

  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.

Why can’t I Unshare an Excel workbook?

If the box is uncheckable (grayed out), most likely shared workbook protection is on. To unprotect the workbook, click OK to close the Share Workbook dialog box, and then click the Unprotect Shared Workbook button on the Review tab, in the Changes group.

How do you make a workbook unshared?

To Un Share an Excel workbook.

On the Review Menu – Choose – Share Workbook. Ensure Allow Changes tick box is unchecked. The above dialog will appear. Ensure you click yes to unshare the Excel workbook.

Why is my shared workbook locked?

If you are trying to co-author, the “locked” error can occur if the file uses a feature that is not supported by co-authoring. Ask the person who has the file open to do one or more of the following. The first thing to try is to turn off the Shared Workbook feature.

IT IS INTERESTING:  Frequent question: What is the difference between a dividend and a capital gain distribution?

Why would you set up a workbook to be shared if you are the only one using the workbook in Excel?

By sharing a workbook: A team can work simeltaneously on the same workbook. No multiple copies , all the data by everyone is in a single workbook. Can be used to collect information for surveys etc.

How do I find the share workbook in Excel?

Click File > Options > Quick Access Toolbar. Open the list under Choose commands from and select All Commands. Scroll down that list until you see Share Workbook (Legacy). Select that item and click Add.

How do you unlock a Excel spreadsheet locked by another user?

To do so, follow these steps:

  1. Save all your work, and then quit all programs.
  2. Press CTRL+ALT+DELETE to open the Windows Security dialog box.
  3. Click Task Manager, and then click the Processes tab.
  4. Click Winword.exe, and then click End Process.
  5. In the Task Manager Warning dialog box, click Yes.

How do you unlock a spreadsheet that is locked for editing?

How to Unlock Excel File Locked for Editing – 5 Ways

  1. Quit All Instance of Excel.
  2. Use Windows Management Console.
  3. File Is Editing by Another User.
  4. Remove Unsupported Features.
  5. Check Your File Format.

How do I unlock an Excel spreadsheet for editing online?

Step 1: Open the worksheet you want to unprotect. Step 2: Click on File > Info > Unprotect Sheet. Step 3: Or go to Review Tab > Changes > Unprotect Sheet.