How do you unlock Excel file that is locked for editing by me?

1. Please open Excel, click File> Options> Save, under Cache Settings, tick the option “Delete files from the Office Document Cache when they are closed” and click Delete cached files. After that, reopen Excel and open the workbook again.

How do I unlock a shared file that is locked for editing?

To resolve this issue, first confirm that another user on the network does not have the document open. If the document is in use, open the document as read-only. If it is not in use, quit all instances of Word, and then remove the owner file.

Why is a shared Excel workbook locked for editing?

It’s just a temporary file that needs to be deleted. Excel (and probably any MS Office application) creates a temporary file in the same folder as the document when someone opens it on the network. The name of the temporary file is the same as the document with a tilde ( ~ ) in front of it.

How do I unlock a spreadsheet on a shared drive?

Unlocking a Shared Folder

  1. Go to Control Panel > Privilege > Shared Folders > Shared Folder.
  2. Locate a locked shared folder.
  3. Under Action, click . The Unlock Folder window appears.
  4. Select one of the following options. Option. User Action. Input Encryption Password. Enter the encryption password.

How do I force someone out of an Excel file?

Select someone from the list of active users and click Remove User to remove a specific user. Click OK to close the window after removing as many users as you want.

How do you unlock a read only Excel file?

To do so:

  1. From Explorer, search for the Excel File in question.
  2. Right-click on the Excel file you want to edit.
  3. Select Properties.
  4. Go to the bottom of the General Tab.
  5. Uncheck the Read Only check box.
  6. Click OK to finalize.

How do I kick someone out of a shared Excel file?

How do I unlock a file for editing?

Right-click on the file. In the menu that appears, select Lock File. To unlock, right-click the file and select Unlock File.

How do you unlock a document to share?

How to: Unlocking a shared file on a Windows Share

  1. Step 1: Open MMC. Open MMC by running the command mmc.exe, then go to File, Add/Remove Snap-in….
  2. Step 2: Select “Shared Folders” snap-in. After clicking on Shared Folders and then Add >, a properties box will open.
  3. Step 3: Find the Open File.

Can you kick someone out of a shared Excel file?

How do I unlock a shared Excel spreadsheet?

Windows: If possible, remove password encryption or restricted access from the file. Go to File > Info > Protect Workbook and remove any passwords or restricted access settings. Turn off the Refresh data when opening file setting on all tables and PivotTables in the file.

How do I change an Excel File from read only to editable?