excel locked

Question

hello i am having trouble to unlock y excel workbook on my mac air and i an not sure how to unlock it. if there is any suggestionsor anything that can help me please let me know thank you

Answer 1

Hi Sikthia,

I understand that you would like get the access of the file however as per checking If you forget or lose your password, Microsoft can’t retrieve it for you. For more information, you can refer to this link: https://support.microsoft.com/en-US/Excel/protection-and-security-in-excel

Best thing to proceed is you may try to recall commonly used password and try to use it.

Answer 2

Follow these steps depending on how the workbook is locked on Mac.

1. If the worksheet is protected (can open but can’t edit cells)

1. On the ribbon, go to Review.
2. Click Unprotect Sheet.
3. If prompted, enter the sheet password.
4. After it’s unprotected, you can also unlock specific cells:
   • Select the cells or range.
   • On the Format menu, click Cells.
   • Go to the Protection tab and clear the Locked checkbox.

If you need to unlock graphics/objects:

1. Select the graphic or object.
2. On the Format menu, choose the appropriate command (for example Shape, Text, Picture, Format Object, or Control).
3. Go to Properties or Protection and clear Locked (and Lock text if present).

2. If the workbook itself is protected (structure or password)

1. Open the workbook.
2. On the Review tab, click Protect Workbook or Unprotect Workbook (the button changes depending on current state).
3. When prompted, enter the current password.
   • Clicking Unprotect Sheet removes the sheet password.
   • To remove a workbook password completely, after unprotecting, click Protect Workbook again and click OK without entering a new password.

3. If the file is “locked for editing” by another user or by the system

1. Make sure the workbook is closed on all devices where the same account is signed in.
2. Wait a few minutes so the server can release the lock.
3. If someone else has it open, ask them to close it or check it in, or open the file as read-only until they are done.
4. If trying to co-author and you still see a lock, make sure the file is saved as .xlsx, .xlsm, or .xlsb.

4. If the file is password-protected to open and the password is forgotten

• There is no built-in way in Office to bypass or recover a forgotten open password. The file cannot be opened without the correct password.

If the problem is that Excel becomes unresponsive and won’t let any cells be selected after a while, restarting the Mac has resolved that behavior in similar cases.

---

References:

• Lock cells to protect them in Excel for Mac
• Protect a worksheet in Mac
• Change or remove workbook passwords
• Excel file is locked for editing
• Excel unable to edit - Microsoft Q&A
• password question - Microsoft Q&A