- Open the homescreen for Google Drive, Google Docs, Google Sheets, or Google Slides.
- Select a file or folder.
- Click Share or Share .
- Find the person you want to stop sharing with.
- To the right of their name, click the Down arrow. Remove.
- To save changes, click Save.
Click the Permissions menu on the right and select Can Edit or Can View. You can change these permissions at any time by right-clicking that person’s name in this Share window.
Select File > Info. Select the Protect Workbook box and choose Encrypt with Password. Enter a password in the Password box, and then select OK. Confirm the password in the Reenter Password box, and then select OK.
How to unshare an Excel file
- We will click on the Reviews Tab, Changes group and select Share Workbook.
- Under the Editing tap, we will unmark Allow changes by more than one user at the same time. Next, we will select OK.
How do I force an Excel file to be locked by another user?
Go to Computer Management -> System Tools -> Shared Folders -> Open Files to find out who has a document locked. If the user can’t be contacted to disconnect themselves, you can forcefully do so by right clicking the locked file and selecting Close Open File (warning: the user might lose their changes).
How do you remove an Excel file that is locked by another user?
- Save all your work, and then quit all programs.
- Press CTRL+ALT+DELETE to open the Windows Security dialog box.
- Click Task Manager, and then click the Processes tab.
- Click Winword.exe, and then click End Process.
- In the Task Manager Warning dialog box, click Yes.
Click Review > Share Workbook. On the Editing tab, select the Allow changes by more than one user … check box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK.
How do you prevent two users from editing the same Excel file at the same time?
If you use Excel Online on SharePoint site, to disable editing the same cell for multiple users at the same time, you need to disable co-authoring. To do that, you can disable versioning and enable Check In/Out.
How do you lock a spreadsheet so only one person can edit?
As in Excel, click the “File” tab in the ribbon menu; click “Info” and then click “Protect Document” to restrict who can edit your Word document. The options are similar to Excel, and there is also a “Restrict Editing” feature that lets you specify specific types of editing that are and are not allowed.