Fix Access Denied for a Shared OneDrive for Business Workbook
Question details
The recipient needs to open a shared Excel workbook in OneDrive for Business.
- Product
- OneDrive for Business and Excel for the web
- Device & OS
- not provided
- Scenario
- A recipient opens a shared XLSX workbook whose owner can see the recipient's email address in OneDrive.
- Observed behavior
- The browser displays an Access Denied message saying the recipient does not have permission to open the file.
Confirm the exact email address the owner used to share the workbook and locate the original sharing link. The owner may need to review the file's access settings, and an organization administrator may need to check sharing policies.
Check the signed-in account and workbook permissions
Use this approach when the recipient is listed on the file but cannot open it in the browser.
Open the sharing link and select the Microsoft 365 profile icon to check the signed-in account. If it differs from the shared address, sign out and sign in with the intended work or school account, then reopen the link.
Ask the owner to find the workbook in OneDrive for Business, select it, and open Manage access. Check that the recipient has access to the file and that any specific-people link includes the intended email address.
If access still fails, ask the owner to remove the affected recipient's permission or sharing link in Manage access, then select Share and invite the correct email address again. Send the recipient the new link.
If the new link still fails, ask the Microsoft 365 administrator to review external sharing and account restrictions. Consult Microsoft's SharePoint and OneDrive access-denied guidance at https://docs.microsoft.com/en-us/sharepoint/troubleshoot/administration/access-denied-or-need-permission-error-sharepoint-online-or-onedrive-for-business.
Try opening the workbook in Excel for desktop
Try the desktop app after confirming that the recipient has permission to open the workbook.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheet files. Open an accessible local copy of an XLSX workbook in WPS Spreadsheets for a straightforward transition; WPS cannot bypass OneDrive sharing permissions.
Frequently Asked Questions
Why am I denied access when the owner can see my email address?
The browser may be signed in to a different Microsoft account, the sharing link may not include your account, or an organization policy may restrict access. Check the profile icon and ask the owner to review Manage access.
How can the owner give me access again?
The owner can select the workbook in OneDrive, open Manage access, remove the affected permission if necessary, and use Share to invite the correct email address again.
Can I open the workbook in desktop Excel without permission?
No. Excel for desktop still requires access to the OneDrive or SharePoint file. Once permission is confirmed, use the sharing link's Open in desktop app option or look under File > Open > Shared with me.
Can WPS Office fix a OneDrive access-denied error?
No. The owner or administrator must resolve the OneDrive or SharePoint permission issue. You can use WPS Spreadsheets to open an XLSX copy that you are authorized to access.
