Permission & Access Issues

Can a Global Admin Unlock a Password-Protected Excel File in SharePoint?

Guest Writer Oct 1, 2026 868 views

Question details

The organization needs to remove password protection from an Excel file left by a former user in SharePoint using Global Administrator privileges.

Can a Global Administrator Unlock a Password-Protected Excel File in SharePoint?

Product: Microsoft Excel and SharePoint
Device & OS: not provided
Scenario: A former employee locked a shared Excel file with a password, and the organization is trying to regain access to the data.
Observed behavior: SharePoint administrator permissions do not bypass or remove the password protection applied natively by the Excel application.

Before you start

Determine whether the file has 'Open' encryption (requires a password to view) or 'Modify' protection (requires a password to edit cells). Always create a backup copy of the Excel file before attempting any recovery steps.

Solution 1Recommended

Restore a Previous Version via SharePoint Version History

Since administrator rights cannot bypass Excel file encryption natively, restoring an older version of the file from before the password was applied is the most reliable official solution.

Microsoft Excel applies password encryption directly to the file contents. SharePoint simply hosts the file and does not manage the internal Office encryption layer. Therefore, even a Global Administrator cannot force-unlock an encrypted file.

Access the SharePoint Document Library

Navigate to the specific SharePoint site and open the Document Library where the password-protected Excel file is stored.

Open Version History

Right-click the Excel file (or select the three dots icon next to it) and click on 'Version History' from the context menu.

Restore an Older Version

Locate a version of the file saved before the former employee applied the password. Click the drop-down arrow next to the date and select 'Restore'. Check if the restored version opens without a password.

Restore a Previous Version via SharePoint Version History

Data Loss Warning: Restoring a previous version will revert the document to its state at that specific time. Any data added after that version was saved will be lost.

Solution 2

Remove Worksheet Protection Manually (For Editable Access)

If you can open the file but cannot modify the cells, you can bypass worksheet protection by modifying the underlying XML code of the Excel file.

Free Microsoft Office alternative

Manage and Protect Your Spreadsheets Easily with WPS Office

Dealing with forgotten Microsoft Excel passwords can be frustrating because the encryption is deeply embedded. Prevent future hassle by using WPS Office, a powerful and lightweight alternative that offers seamless spreadsheet management, robust compatibility with Microsoft formats, and intuitive document security features—all for free.

1. Download and Install: Get WPS Office from the official website and complete the quick installation process.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing .xlsx files without worrying about formatting loss.
3. Manage Document Security: Navigate to the 'Review' tab to easily set up, manage, or remove document passwords and permissions for your team.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsIntuitive and easy-to-manage document encryption toolsLightweight application that runs smoothly on any deviceFamiliar user interface requiring zero learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can Microsoft Support unlock my password-protected Excel file?

No. Due to strict privacy and security policies, Microsoft Support cannot assist in bypassing or removing passwords from encrypted Office files.

What is the difference between an 'Open' password and Worksheet Protection?

An 'Open' password uses strong encryption to prevent anyone from viewing the file contents without the password. Worksheet protection simply locks specific cells or formatting from being changed, but the file can still be opened and read.

Why doesn't my Global Admin account have access to all encrypted files?

Global Administrator permissions grant access to SharePoint administration and file management (like deleting or moving files). However, Excel file encryption is applied at the file level by the application itself, which operates independently of SharePoint's permission hierarchy.

Document & File Issues