Access Denied to Excel Spreadsheet

Question

I need to be able to access my excel spreadsheet however it has denied me access. How can I gain access to my excel spreadsheet?

Answer 1

Hi Gloria Fierro,

This usually indicates that Windows, OneDrive, or Excel doesn’t currently recognize your account as having permission to open or edit the file. It can also happen if the file was shared to a different Microsoft account, the file owner or permissions are incorrect, or the workbook is opening in a restricted or locked state.

Steps to try

1. Copy the file to your Desktop and try opening the copy from there.
2. Right‑click the file > Properties and check for an Unblock option. If it’s present, enable it and click Apply.
3. Right‑click the file > Properties > Security and confirm your Windows account has at least Read permission.
4. If your account isn’t listed, select Advanced > Change Owner and set it to your Windows account (only if this is your personal file).
5. In Excel, go to File > Open > Browse, select the workbook, click the arrow next to Open, then choose Open and Repair.
6. If the file is stored in OneDrive, make sure Excel and OneDrive are signed in with the same Microsoft account that owns the file or was explicitly given access.
7. If the file shows as Read‑only or Locked for editing, check the OneDrive sync status column for any warning icons (such as a red X).
8. Test in Safe Mode: press Windows + R, type excel /safe, and try opening the file.
   • If it opens there, an add‑in is likely interfering.
9. If needed, run Quick Repair for Microsoft 365.

To help narrow this down further, please reply with:

• The exact last line of the error message (in quotes)
• Where the file is stored (OneDrive / Desktop / Documents / external drive)
• Whether it opens in Excel for the web

That should help pinpoint whether this is a permissions, sync, or Excel‑side issue.

Please let me know if this proves useful to you, or if you would like further assistance.

I'm looking forward to your reply.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Several different issues can cause an “Access denied” message in Excel. Use the checks below in order.

1. Check if the file has restricted permissions (IRM / sensitivity labels)
   • Open the workbook in Excel. If a yellow Message Bar appears, select View Permission.
   • Or look at the status bar for a message such as This workbook contains a permissions policy and select it.
   • If access is denied, either:
     • Sign in with the account that was granted rights to the file, or
     • Ask the file owner to grant the correct permissions or remove restricted access.
   • If an error indicates the Office version does not support the protection policy (for example, dynamic watermarking), update Office to the latest version or open the file in Office for the web.
2. Check folder and file permissions (especially if stored on a network or redirected folder)
   • If the file is in a folder redirected by Group Policy (e.g., Documents redirected to a network location), the parent folder might not grant the needed permissions.
   • An administrator should ensure the parent folder of the redirected folder has at least these permissions for Authenticated Users:
     • Traverse Folder / Execute File
     • List Folder / Read Data
     • Read Attributes
   • Enterprise and Domain Administrators should have Full Control on that parent folder.
3. If the file is on a UNC/network share and you can open but not save
   • When saving to a UNC share, Excel creates a temporary copy, then deletes the original and replaces it.
   • If the user does not have Delete permission on that share, saving fails with Access Denied. Contact your administrator.
   • Ask the administrator to grant Delete permission on the share for the account that is saving the file, or save the file to a location where Delete permission is available.
4. If Excel shows “Access denied” and then closes when opening/saving
   • This can occur when opening/saving to a redirected folder whose parent folder lacks Read Attributes for the user.
   • Have an administrator adjust the parent folder permissions as in step 2 so that Authenticated Users have Read Attributes.

If none of these apply, provide details such as where the file is stored (local PC, OneDrive, SharePoint, network share), the exact error text, and whether others can open the same file; troubleshooting will then focus on that specific scenario.

---

References:

• Open a file that has restricted permissions
• You receive an "Access denied" error message, and the program unexpectedly quits when you try to open or save a file in an Office program
• "Access Denied" error message when you save a workbook to a UNC share in Excel 2010 or Excel 2013