How to Restore a Viewing Password in an Excel Workbook
Question details
The user wants to know how to restore a viewing password prompt for an Excel workbook that is no longer requesting it upon opening.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to open a password-protected Excel workbook, but the password prompt does not appear.
- Observed behavior
- The workbook opens without requesting a viewing password, which often occurs because the file only has worksheet or editing protection applied instead of full file encryption.
Ensure you have the desktop version of Excel installed, as managing full file encryption settings often requires the desktop application rather than the web version.
Verify and Re-apply Full File Encryption
Check if the workbook is fully encrypted or just protected for editing, and re-apply the correct encryption if necessary.
Often, a workbook stops asking for a viewing password because it was mistakenly saved with only worksheet protection rather than being fully encrypted. Full file encryption ensures the file cannot be opened at all without the correct password.
Launch the affected workbook in the desktop version of Excel. Click on the 'File' tab in the top-left corner and select 'Info'.
Under the 'Protect Workbook' section, check the status. If it only mentions that specific sheets are protected from editing, full file encryption is missing.
Click the 'Protect Workbook' dropdown menu and choose 'Encrypt with Password'. Enter your desired viewing password, click 'OK', and confirm the password.
Save the workbook and close it. Reopen the file to test and confirm that the viewing password prompt now appears before the file opens.
Test in an Incognito or InPrivate Window
Use a private browsing window to rule out cache or session issues that might bypass the password prompt in Excel for the Web.
Contact Microsoft 365 Support
If the workbook is correctly encrypted but Excel for the Web still bypasses the viewing password, escalate the issue to support.
Easily Password Protect Workbooks in WPS Office
WPS Office provides robust file encryption capabilities to ensure your sensitive data is always protected. Easily set up a viewing password for your spreadsheets and enjoy seamless compatibility with Microsoft Excel formats.
- 1. Open Your Workbook: Launch WPS Spreadsheets and open the file you want to protect.
- 2. Navigate to Document Encryption: Click on the 'Menu' button in the top left corner, hover over 'Document Encryption', and select 'Encryption'.
- 3. Set the Viewing Password: In the 'Document password' field, type your desired viewing password and click 'OK' to apply full file encryption.
- 4. Save and Verify: Save the file and close it. Reopen the spreadsheet to verify that WPS securely prompts you for the password before displaying any content.
Frequently Asked Questions
What is the difference between worksheet protection and full file encryption?
Worksheet protection prevents users from editing or modifying specific cells within a sheet, but anyone can still open and view the file. Full file encryption requires a viewing password before the workbook can even be opened or its contents displayed.
Why is my Excel viewing password not working in the web version?
This can happen due to browser cache issues, active session tokens, or a synchronization delay with Microsoft 365 servers. Testing the file in an Incognito window can help identify if it is a local browser issue.
Can I recover a forgotten viewing password for my Excel workbook?
No, if you forget or lose the viewing password used for full file encryption, Microsoft Excel cannot recover it. Always keep a secure backup of your passwords to avoid losing access to your data.
How do I remove a viewing password from a workbook?
Open the workbook by entering the current viewing password. Go to File > Info > Protect Workbook > Encrypt with Password. Delete the existing password so the field is completely blank, click OK, and save the file.
