Quick answer
For the classic blank grey window, go to File → Options → Advanced, scroll to General and untick "Ignore other applications that use Dynamic Data Exchange (DDE)", then reopen the file. If the file came from email or a download, click Enable Editing in the yellow bar, or right-click the file → Properties → Unblock.
WHY IT HAPPENS
Excel opens — the file just doesn't.
When Excel launches to a blank grey screen, the program is fine; something is stopping the file from loading into it. The usual culprits are a Windows setting called DDE that Excel uses to hand files to itself, a hidden window, Protected View holding back an emailed or downloaded file, or the file being blocked by Windows because it came from the internet. Work through the steps below.
HOW TO FIX IT
Work through these in order.
- Turn off the DDE settingThis fixes the blank grey window in most cases. Open Excel, go to File → Options → Advanced, scroll down to the General section and untick "Ignore other applications that use Dynamic Data Exchange (DDE)". Click OK, then try opening your file by double-clicking it again.
- Unhide the windowIf Excel opens but the sheet area is blank, the workbook window may be hidden. On the View tab, click Unhide (in the Window group). If a file is listed, select it and click OK to bring it back into view.
- Handle Protected View for emailed or downloaded filesFiles that arrive by email or download open in Protected View for safety, and can show a blank or grey screen until you act. Look for the yellow bar across the top and click Enable Editing. Only do this for files from people you trust.
- Unblock the file in its PropertiesIf a downloaded file still won't open, Windows may have blocked it. Close Excel, right-click the file in File Explorer, choose Properties, and on the General tab tick Unblock near the bottom. Click OK and open it again.
- Turn off hardware graphics accelerationA blank or half-drawn window can also be a graphics glitch. Go to File → Options → Advanced and, under Display, tick Disable hardware graphics acceleration. Click OK and restart Excel.
- Try Open and RepairIf the file itself is damaged, open Excel first, go to File → Open → Browse, click the file once to select it, then click the small arrow next to the Open button and choose Open and Repair. Let Excel attempt to recover the contents.
- Run an Office Quick RepairIf several files behave the same way, the Office install may be the issue. In Windows Settings → Apps → Installed apps, find Microsoft 365 / Office, choose Modify → Quick Repair — and if needed, Online Repair — which resets Office without deleting your files.
Only one important file affected? If a single critical spreadsheet still won't open after Open and Repair, don't keep forcing it — repeated attempts can make things worse. Restore the last good copy from your backup or OneDrive/SharePoint version history, and get your IT provider to check whether the file is genuinely corrupt before you rely on it again.
