Fix Excel Password Protection Not Working in Microsoft 365 Personal
Question details
The user is unable to password protect Excel files and is receiving an administrator service error despite having a personal subscription.
- Product
- Microsoft Excel / Microsoft 365 Personal
- Device & OS
- not provided
- Scenario
- Attempting to encrypt an Excel workbook with a password or restrict editing using the Protect Workbook feature.
- Observed behavior
- Password protection fails to activate, often displaying the error message 'Your organization’s administrator turned off the service required to use this feature'.
Ensure you save a backup copy of your unencrypted Excel workbook before troubleshooting, and verify that your device is connected to the internet so Excel can validate your subscription status.
Verify Subscription and Re-apply Password Protection
Ensure your Microsoft 365 Personal subscription is active and apply the correct encryption settings through the File Info menu.
Even on personal accounts, Excel may restrict security features if it cannot verify an active Microsoft 365 subscription.
Additionally, it is important to choose the right protection level, as workbook protection and file encryption serve different purposes.
Open Excel, click on 'File' in the top ribbon, select 'Account', and verify that your Microsoft 365 Personal subscription is active under the Product Information section.
Navigate to 'File', then click on 'Info'. Look for the 'Protect Workbook' dropdown menu.
Select 'Encrypt with Password' from the dropdown list, type your desired password, and confirm it to require a password every time the file opens.
Alternatively, select 'Protect Sheet' to restrict editing on specific cells, or choose 'Protect Workbook' to prevent structural changes like adding or deleting sheets.
Test File Locally and Use Safe Mode
Bypass potential add-in conflicts, cloud synchronization errors, or connected experience glitches by using Excel Safe Mode and local storage.
Password Protect Your Spreadsheets Easily with WPS Office
If Microsoft Excel continues to display administrator errors for your personal account, you can effortlessly encrypt and password-protect your workbooks using WPS Office. It provides robust document security and maintains full format compatibility with Excel.
- 1. Open Spreadsheet: Launch WPS Spreadsheets and open the workbook you want to protect.
- 2. Access Encryption Menu: Navigate to the 'Menu' at the top left corner, hover over 'Document Encryption', and select 'Encryption'.
- 3. Set Password: Enter your desired password in the 'Document Password' field and confirm it.
- 4. Save File: Click 'OK' and save your spreadsheet to apply the password protection successfully.
Frequently Asked Questions
Why does Microsoft 365 Personal show an 'organization's administrator' error?
This error can occur on personal non-enterprise accounts due to glitches in Microsoft's 'connected experiences' privacy settings, corrupted Office configurations, or conflicting third-party add-ins overriding default permissions.
What is the difference between Protect Workbook and Encrypt with Password?
'Encrypt with Password' locks the entire file, requiring the user to enter a password just to open and view the document. 'Protect Workbook' simply locks the structure of the workbook (like adding, moving, or deleting sheets) but allows users to open and view the file without a password.
Can I remove a password from an Excel file if it's no longer needed?
Yes, provided you know the current password. Open the encrypted file, go to File > Info > Protect Workbook > Encrypt with Password, delete the existing password from the text box so it is blank, and click OK.
