'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Password Prompt Not Showing for Excel Files on Windows
Question details
The user is unable to open password-protected .xlsm Excel files on Windows because the password prompt does not appear, though the files open correctly on mobile devices.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to open password-protected macro-enabled (.xlsm) Excel files synced via OneDrive on a Windows desktop application.
- Observed behavior
- The Excel application launches but fails to display the password entry prompt, effectively freezing the process and preventing the user from accessing the file content.
Ensure your Windows operating system and Microsoft Office suite are fully updated, and verify that the file is completely synced from OneDrive to your local drive before attempting to open it.
Open Excel in Safe Mode to Bypass Add-ins
Use Office Safe Mode to disable third-party add-ins and customizations that might be interfering with the display of the password prompt.
Sometimes, Excel add-ins or corrupted startup configurations can block interactive UI elements like the password prompt from rendering. Launching Excel in Safe Mode helps isolate whether the issue is caused by the Excel installation itself or an external add-in.
Press the Windows key + R on your keyboard to open the Run dialog box.
Type 'excel /safe' into the text box and press Enter or click OK.
Once Excel opens in Safe Mode, click on 'File', select 'Open', navigate to your OneDrive folder, and choose the affected .xlsm file to see if the prompt appears.
Download a Local Copy from OneDrive
Download the file directly to your local drive to rule out OneDrive synchronization issues causing the file to stall on opening.
Recreate the Password-Protected Workbook
Use another device where the file opens successfully (like a mobile phone) to remove and reapply the password, clearing potential file corruption.
Open Password-Protected Excel Files Instantly with WPS Office
If Microsoft Excel continues to experience UI glitches and fails to display the password prompt, switch to WPS Office. It is a highly compatible, free Office suite that reliably handles .xlsm formats and encrypted workbooks without stalling.
- 1. Install WPS Office: Download and install the free WPS Office suite on your Windows PC.
- 2. Open your protected file: Right-click your .xlsm file, select 'Open with', and choose WPS Spreadsheets.
- 3. Enter your password: Type your password in the prompt that appears and instantly access your data.
Frequently Asked Questions
Why does my Excel file open as a blank screen instead of asking for a password?
This can happen due to a glitch with Excel add-ins, outdated Office versions, hardware graphics acceleration conflicts, or an incomplete OneDrive synchronization.
Can I remove the password from an .xlsm file without opening it?
No. By design, you must first supply the correct password to decrypt and open the file before you can access the security settings to remove or change the password.
Does Excel for the Web support password-protected .xlsm files?
Excel for the Web has limitations with macro-enabled (.xlsm) and heavily protected workbooks. It is recommended to use a desktop client like Microsoft Excel or WPS Office to view and edit these files fully.
Will disabling hardware graphics acceleration fix the missing prompt?
In some older versions of Office, UI elements like password prompts might fail to render due to display driver issues. Disabling hardware graphics acceleration in Excel Options > Advanced > Display can sometimes resolve this.
