Permission & Access Issues

Fix: Excel Says Your Account Does Not Have Permission to Open a Workbook

Partner Editor Sep 30, 2026 869 views

Question details

The user is unable to open an Excel workbook after switching from a Microsoft 365 business account to a personal subscription due to a permission error.

Fix: Excel Says Your Account Does Not Have Permission to Open a Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to open an Excel file previously created or saved under a corporate Microsoft 365 account using a new personal subscription.
Observed behavior: Excel displays an error message stating that the signed-in account does not have permission to open the workbook.

Before you start

Verify which Microsoft account you are currently logged into within Excel, and determine if the file in question is stored locally on your device or in a cloud storage service like OneDrive or SharePoint.

Solution 1Recommended

Request File Access from the Former Organization

Because the file is tied to a business account, you must contact the organization's IT administrator to grant access or transfer ownership to your personal account.

When files are created using a Microsoft 365 business account, they are often protected by organizational policies or stored in corporate SharePoint and OneDrive environments. Signing in with a personal account does not bypass these enterprise permissions.

Contact the IT Administrator

Reach out to the IT administrator or your former manager at the organization where the file was originally created.

Request File Sharing

Ask them to share the specific workbook directly with your personal Microsoft account email address, ensuring external sharing is enabled.

Request an Unrestricted Copy

Alternatively, ask the administrator to download a local copy of the file, remove any enterprise protection or sensitivity labels, and send it to you directly.

Request File Access from the Former Organization

Organizational Policies: Some organizations have strict data loss prevention (DLP) policies that prevent sharing internal files with external personal accounts. The admin may need to manually bypass this if permitted.

Solution 2

Sign In Using the Original Business Account

If your former business account has not yet been deactivated, you can temporarily switch accounts in Excel to access and download the file.

Free Microsoft Office alternative

Switch to WPS Office for Hassle-Free Local File Management

Tired of complicated cloud permission issues and subscription lock-ins? WPS Office is a powerful, free alternative to Microsoft Office that makes managing local and cloud files easy, without restrictive business account barriers.

1. Download WPS Office: Visit the official WPS website to download the free installation package for your device.
2. Install the Software: Run the installer and follow the on-screen instructions to complete the setup.
3. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your unprotected local .xlsx files without worrying about Microsoft account restrictions.

Avoid frustrating account permission locks on your personal offline files.Fully compatible with Microsoft Excel (.xlsx), Word, and PowerPoint formats.Lightweight installation and a familiar interface for a seamless transition.Free to use with comprehensive spreadsheet analysis and editing tools.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel say I don't have permission even though I originally created the file?

If you created the file while signed into a Microsoft 365 business account, the file is legally owned by the organization and likely protected by their SharePoint or OneDrive infrastructure. When you switch to a personal account, you lose the corporate credentials required to authenticate and open it.

Can I remove the permission restriction without contacting the IT admin?

No. If the file is protected by Microsoft Information Protection or stored in a restricted enterprise cloud environment, only an authorized account from that organization can grant access or remove the restriction.

How do I check which account I am currently signed into in Excel?

Open Excel, click on 'File', and select 'Account' from the bottom left menu. Under the 'User Information' section, you will see the name and email address of the currently signed-in Microsoft account.

Document & File Issues