- #EXCEL FILE LOCKED FOR EDITING HOW TO UNLOCK UPDATE#
- #EXCEL FILE LOCKED FOR EDITING HOW TO UNLOCK WINDOWS#
Click the File tab in the top left corner, scroll down to select Add/Remove snap-in. The Microsoft Management Console window pop up.
#EXCEL FILE LOCKED FOR EDITING HOW TO UNLOCK WINDOWS#
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.
If you’re editing your macro file every day, perhaps you need to consider making your macros more generic so they take parameters from, say, an InputBox. I think that for most users, this will be sufficient.
#EXCEL FILE LOCKED FOR EDITING HOW TO UNLOCK UPDATE#
Please note that if you want to edit the file again, to add another macro for example, you’ll have to un-check the read-only box, update the file and then recheck it. For example, I had both PERSONAL.XLSB and PERSONAL-2.XLSB which would load at startup for me. Then, on the General tab under Attributes, check the “Read-only” box.ġ You can have more than one PERSONAL.XLSB file.Highlight them and view their properties (Right-click -> Properties).