Fix a Blank or Hidden Excel Workbook on Mac and Windows
Question details
The user needs to display an Excel workbook that appears to open but is not visible.
- Product
- Microsoft Excel
- Device & OS
- Mac and Windows
- Scenario
- Opening a workbook that contains data.
- Observed behavior
- Excel displays a blank window or hides the workbook, which may remain open in the background and prompt for saving when Excel closes.
Open the affected workbook in Excel and check whether its name appears in the Window menu. Also check whether the problem affects one workbook or every file you open.
Show or unhide the Excel workbook window
Use this when the workbook is open in Excel but its document window is hidden.
In Excel, select File > Open and choose the affected workbook.
On Mac, check Window > Show or Window > Unhide, depending on your Excel version. On Windows, select View > Unhide.
If a list of hidden windows appears, select the workbook and choose OK or the available Show command.
Check the DDE setting in Excel for Windows
Use this when Excel opens blank after you open a workbook from Windows.
Open Excel Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface. Open compatible Excel workbooks in WPS Spreadsheet for an easy transition, though it does not repair Microsoft Excel itself.
Frequently Asked Questions
Why does Excel ask me to save when I cannot see the workbook?
The workbook may still be open in a hidden window. Check Window > Show or Window > Unhide on Mac, or View > Unhide on Windows.
Where is the DDE setting in Excel for Windows?
Select File > Options > Advanced and look under General for Ignore other applications that use Dynamic Data Exchange (DDE). Clear it and select OK.
What if the Unhide command is unavailable?
There may be no hidden workbook window. Check whether the issue affects other files, and on Windows check the DDE setting under File > Options > Advanced.
Can I open an Excel workbook in WPS Office instead?
Yes. In WPS Spreadsheet, use File > Open to select a compatible XLS or XLSX workbook. This provides an alternative way to view the file but does not fix Excel.
