So I'm working on a spreadsheet called "tutoringlogs.ods" when my laptop freezes (OS is Ubuntu if that matters). Nbd, I reboot, and I try to open the spreadsheet again. LibreOffice Calc gives me the error message: Show
OK. So I open up a terminal:
Try to open the file again, and lo and behold...
OK, weird but whatever, it's giving me the option to open a copy so I open the copy and save the copy as 'tutoring.ods'. Now I go back to the terminal:
Self-satisfied, I open tutoringlogs.ods.
:( So for now my tutoring notes file is named 'tutoring.ods', which is fine, but I want answers! LibreOffice must have some kind of system file with a secret list of filenames I can never write to. Please help me find that list so I can edit it and regain control of my life. This doesn't really affect me at all but it's about the principle. UPDATE: I just knew if I posted this it would end up being an embarrassingly obvious answer. Yes, there was a hidden file 🤦♀️🤦♀️🤦♀️🤦♀️🤦♀️🤦♀️ Client for Open Enterprise Server (Novell Client) Client for OES 2 SP3 for Windows Microsoft Office 2013 Microsoft Excel Microsoft Word When attempting to edit a document or spreadsheet, the user gets a message: File in Use <filename> is locked for editing by 'username'. Open 'Read-Only' or click 'Notify' to open read-only and receive notification when the document is no longer in use. Where the name of the user identified is the user who is attempting to open the file. The user is certain that they do not have the file open when the message appears. ResolutionMicrosoft Office users can encounter this problem whether or not Client for Open Enterprise Server is in use. It is not a problem specific to Client for OES itself. There are a number of posts on Microsoft's website regarding this issue, including this thread on answers.microsoft.com. Does this error happen when you edit your word or excel files? It is frustrating and annoying that you can not edit your .doc or .xlsx files in the middle of work. Don't worry. This problem is easy to fix. Read on and get the solutions to handle "Word document locked for editing" and "Microsoft excel is locked for editing". 2 Ways to Unlock Microsoft Word Document That Is Locked for Editing
Fix 1 - Quit All Instance of WordStep 1. Save your work immediately and quit all running programs. Step 2. Type Task Manager in the search box or press Ctrl + Alt + Delete to choose Task Manager in the list. Step 3. Run Task Manager and select the Process tab. Step 4. Find your Winword.exe, click it and choose End task in the bottom right corner. Step 5. End Winword.exe one by one. Step 6. On the Task Manager page, choose the File tab and click Exit. Fix 2 - Uncheck "Encrypt content to secure data"Step 1. Close word file. Step 2. Right-click file and choose Properties > Click Advanced... Step 3. Under the Compress or Encrypt attributes, uncheck Encrypt contents to secure data. How to Unlock Excel File Locked for Editing - 5 Ways
Solution 1 - Quit All Instance of WordStep 1. Save your work first and quit all programs. Step 2. Press Ctrl + Alt + Delete to open the Windows Security Dialog box. Step 3. Select Task Manager and go to the Process tab. Step 4. Click EXCEL.EXE and click the End Task button in the bottom right corner. Step 5. Repeat step 4 to end the process. Step 6. Click the File tab and choose Exit in the top left corner. Solution 2 - Use Windows Management ConsoleStep 1. Remember your file path and file name. Step 2. Press Windows + R to open the Run window. Step 3. Type mmc and press Enter. The Microsoft Management Console window pop up. Step 4. Click the File tab in the top left corner, scroll down to select Add/Remove snap-in... Step 5. On the Add or Remove Snap-ins window, you can check the list of Available snap-ins. Step 6. Choose Shared Folders and then click Add. Step 7. 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. Step 8. Click OK > Go to the Tree view section, choose Shared Folder > click Open Files Step 9. Find your desired files > Right-click it > Choose Close Open File Solution 3 - File Is Editing by Another UserIf 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. If you are don not need to do something urgent right now, you can choose Read-only. 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 .xlsx file. Solution 4 - Remove Unsupported Features (Encryption/Add-ins)In this part, we gonna list several features that might hassle your operation. You can check whether these functions are set in the file. Feature 1 - Excel File Encryption If you have set a password for excel files, we advise you to remove the password encryption. Step 1. Open Microsoft Excel. Step 2. Go to the File tab in the top left corner. Step 3. Choose Info in the left panel > Click Protect Workbook > Select Encrypt with Password Feature 2 - Add-ins Some add-ins may affect your editing files, check the simple steps to disable add-ins: Step 1. Click File > Options > Add-ins Step 2. Choose COM Add-ins > Click Go Step 3. Uncheck all add-ins in the list, and click OK. Step 4. Restart Excel. Feature 3. Refresh Data when opening files (Tables or Pivot Tables) Navigate to Table Tools Design > Refresh > Connection Properties > Uncheck Refresh data when opening file Solution 5. Check Your File FormatIf you and your partners collaborate on the same Excel workbooks, you need to check your file name. Make sure your excel file name is .xlsx, .xlsm or .xlsb. If not, follow the steps to convert file format: Click File tab > Save As > Browse > Save as type > Select .xlsx, .xlsm or .xlsb. Why is My Excel File Locked for Editing?1. The excel file was not closed properly the last time you used it. 2. Your colleague is opening the file. 3. You locked files by yourself. Why Does Word Document Say Locked for Editing?1. Your word file is co-authoring. (Editable by any person.) Another person is editing the document and you have to choose “Read-only”. 2. Improper quit. 3. Another instance of Word is running in the background. Read more articles about Word: Microsoft Word Has Stopped Working How do you unlock an Excel document that is locked for editing by me?Select File > Options > Add-Ins > Excel Add-ins > Go and then clear the check box for the add-in.. If possible, remove password encryption from the file. ... . If possible, remove restricted access.. How do you unlock a document 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 my document locked for editing by me?When Microsoft Word crashes while you are editing a document, it leaves behind temporary files which may give the impression that you are still editing the document. Then, next time you try to open the document, you will receive an error message saying that it's already locked for editing by you.
How do I unlock a document for editing in SharePoint?Logout from MetaShare/SharePoint and login again. Open the document in the Online app and rename the file from there. Check if “Upload Center” has locked this document. If so, you can unlock it from there.
|