You can hide Excel documents in Excel, and when you do, all you see is a blank document panel instead of the actual spreadsheet document. These two options are rather easy to check. If it is, remove the checkmark and select ok. Make sure that "Ignore other applications that use Dynamic Data Exchange (DDE) is not checked.Locate the General group of preferences on the page that opens.
If DDE is disabled in Excel, Excel won't open spreadsheets that you double-click in Explorer, even if it is the default file handler. When users double-click on an Excel spreadsheet document in Explorer for instance, a DDE message is sent to Excel provided that Excel is the associated with the file type. The main functionality of DDE is the sharing of data between Windows programs. It has been superseded largely by other features, but it is still a part of any version of Windows. Option 1: Enable DDEĭynamic Data Exchange (DDE) is not a new feature, as it was introduced by Microsoft in Windows 2.0 back in 1987. The solutions are sorted by simplicity and likeliness. I suggest you apply one after the other, and check each time you made a change whether it resolved the blank document issue in Excel 2016. Fix Excel 2016 opening a blank documentĪs is the case with troubleshooting, there is no single fits-it-all solution available. It was clear that "something" was blocking the selected document from being loaded correctly. I could drag and drop spreadsheets, even the one that Excel 2016 would not open, and it would display fine, and file load operations worked as well. Most interface options are disabled in that mode on top of that.Įxcel functioned normally afterwards. I tried different documents stored in different locations, and opening a document after loading one manually, but all efforts returned the grayish no-document loaded interface. More precisely, it did not open a spreadsheet at all, not even a blank one, but displayed no document in its interface.
0 kommentar(er)
