How to Fix Password-Protected Excel File Opening Blank in Office 2010
Question details
The user needs to view the contents of a password-protected Excel workbook that displays as a completely blank sheet upon opening.

- Product
- Microsoft Excel 2010
- Device & OS
- Windows
- Scenario
- Opening an encrypted Excel workbook after reinstalling Office 2010 or experiencing an application display glitch.
- Observed behavior
- The Excel application opens and accepts the correct case-sensitive password, but then fails to render the data, displaying only a blank screen instead of the worksheet.
Verify that you have the exact, case-sensitive password for the encrypted workbook, as Microsoft Office cannot recover or bypass a lost password.
Open Excel in Safe Mode and Unhide Worksheets
Running Excel in Safe Mode bypasses add-ins that might cause display issues, allowing you to unhide worksheets that may have been intentionally or accidentally hidden.
Conflicting COM add-ins or hidden window settings can prevent workbook data from rendering correctly in Office 2010.
Press the Windows key + R on your keyboard, type 'excel /safe' into the Run dialog box, and press Enter to launch Microsoft Excel in Safe Mode.
Click 'File' > 'Open', navigate to your password-protected workbook, select it, and enter your exact case-sensitive password.
Navigate to the 'View' tab on the top ribbon, click 'Unhide' in the Window group, select the hidden sheets from the list, and click 'OK'.
Go to 'File' > 'Options' > 'Add-Ins'. In the Manage drop-down at the bottom, select 'COM Add-ins' and click 'Go'. Uncheck all add-ins, click 'OK', and save the file as a new XLSX copy.

Use the Built-in Open and Repair Tool
If the workbook is damaged or corrupted, the built-in Open and Repair feature can attempt to recover the blank data.
Repair the Office 2010 Installation
Reinstalling or modifying Office components can sometimes lead to incomplete installations causing blank screens. Running a repair fixes broken application files.
Open Password-Protected Excel Files Easily with WPS Office
If Microsoft Excel 2010 continues to display a blank screen due to software glitches, you can easily bypass the issue by opening your workbook in WPS Office. WPS Spreadsheets is fully compatible with Microsoft Excel formats (.xlsx, .xls) and seamlessly supports password-protected files, allowing you to access your data instantly.
- 1. Download and Install WPS Office: Download WPS Office for free from the official website and run the installer on your Windows PC.
- 2. Open WPS Spreadsheets: Launch the WPS Office suite and click on 'Spreadsheets' from the main dashboard.
- 3. Open the Encrypted File: Click 'Menu' > 'Open', browse your computer for the password-protected Excel file that was showing up blank, and select it.
- 4. Enter the Password: Type your exact case-sensitive password in the security prompt box and click 'OK' to view your fully rendered spreadsheet data.

Frequently Asked Questions
Why does my Excel file open as a blank grey screen?
A blank screen often occurs due to hardware graphics acceleration conflicts, incompatible COM add-ins, corrupted software components, or if the workbook window was intentionally hidden via the View tab and saved in that state.
Can I recover my Excel file if I forgot the password?
Microsoft does not provide utilities or services to bypass, retrieve, or recover lost passwords for encrypted workbooks. You must remember the exact case-sensitive password to decrypt and view the file content.
What does the 'excel /safe' command do?
Running 'excel /safe' starts the application in Safe Mode, which temporarily disables all custom add-ins, customized toolbars, and automated startup folders to help users isolate the cause of crashes or display issues.
How do I fix incorrect file associations for Excel workbooks?
Right-click your Excel file in Windows File Explorer, select 'Open with' > 'Choose another app', select Microsoft Excel (or WPS Office), check the box that says 'Always use this app to open .xlsx files', and click OK.




