Refresh Data when opening files (Tables or Pivot Tables) Uncheck all add-ins in the list, and click OK.įeature 3. Some add-ins may affect your editing files, check the simple steps to disable add-ins: Choose Info in the left panel > Click Protect Workbook > Select Encrypt with Password Go to the File tab in the top left corner. If you have set a password for excel files, we advise you to remove the password encryption. You can check whether these functions are set in the file.

In this part, we gonna list several features that might hassle your operation. xlsx file.ĭownload for Mac  Trustpilot Rating 4.4 Solution 4 - Remove Unsupported Features (Encryption/Add-ins) And, if you need to do something urgent like editing important file details, you can contact who opened the excel file and talk to somebody to close the. If you are don not need to do something urgent right now, you can choose Read-only. If your files are set up to be edited by more than one person, the reason your files can not be edited is that it is being used by other people. Solution 3 - File Is Editing by Another User Find your desired files > Right-click it > Choose Close Open File Click OK > Go to the Tree view section, choose Shared Folder > click Open Files Under the 'Select the computer you want this snap-in to manage.', you can check the Local computer if you've logged in to the local server, if not, you can choose Another computer.

Choose Shared Folders and then click Add. On the Add or Remove Snap-ins window, you can check the list of Available snap-ins. Click the File tab in the top left corner, scroll down to select Add/Remove snap-in. The Microsoft Management Console window pop up. Press Windows + R to open the Run window. Solution 2 - Use Windows Management Console Click the File tab and choose Exit in the top left corner. Click EXCEL.EXE and click the End Task button in the bottom right corner.

Select Task Manager and go to the Process tab.

Press Ctrl + Alt + Delete to open the Windows Security Dialog box. Save your work first and quit all programs. How to Unlock Excel File Locked for Editing - 5 Ways Under the Compress or Encrypt attributes, uncheck Encrypt contents to secure data. Right-click file and choose Properties > Click Advanced. Fix 2 - Uncheck 'Encrypt content to secure data' On the Task Manager page, choose the File tab and click Exit. Find your Winword.exe, click it and choose End task in the bottom right corner. Run Task Manager and select the Process tab. Type Task Manager in the search box or press Ctrl + Alt + Delete to choose Task Manager in the list. Save your work immediately and quit all running programs.

How to unlock selection in word