Excel refuses to open some workbooks, blank screen.

[eduzs]

Excel is refusing to open some workbooks, showing a blank screen. If I go to immediate window workbooks.count = 1 (personal.xlsb, not the xlsx), the workbook is not show in unhide option. The workaround I found to work is open a workbook (not the problematic), open the problematic workbook, go to ribbon View/Unhide and unhide the workbook.
I found this link:
https://docs.microsoft.com/en-ca/office/troubleshoot/excel/excel-opens-blank
None proposed solution worked.
Excel 2010 + Windows 10.
Thanks

 

[eduzs]

After checking/unchecking "Ignore other applications that use Dynamic Data Exchange (DDE)" in excel options and close and reopen, repeating a few times, I think that the problem is seem gone.
Actually, I cleared everything in the general options tab, after the problem disappeared, I re-enabled the options again, except for DDE.

 

[Aron_C]

I know this is an old post but, I also faced the same issue. This blog helped me: How to fix Excel 2016 opening blank workbook issue