Under Editing options, do one of the following: To enable Edit mode, select the Allow editing directly in cells check box. , click Excel Options, and then click the Advanced category. How do I enable editing in Excel in Windows 10?Įnable or disable Edit mode Click File > Options > Advanced. If possible, remove password encryption from the file.Select File > Options > Add-Ins > Excel Add-ins > Go and then clear the check box for the add-in…. Inactivate an add-in that’s causing the lock. How do I fix a locked Excel file for editing? 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). Go to Computer Management -> System Tools -> Shared Folders -> Open Files to find out who has a document locked. How do I unlock a shared Excel file for editing? Select all contents in the Password to open box or the Password to modify box, and then press DELETE.
How do I remove a lock from an Excel file?
