SOLVED

Workbook Not Displaying Sheets when Opening File

%3CLINGO-SUB%20id%3D%22lingo-sub-2339338%22%20slang%3D%22en-US%22%3EWorkbook%20Not%20Displaying%20Sheets%20when%20Opening%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339338%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Everyone%2C%26nbsp%3BI%20am%20lost!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20some%20reason%2C%20when%20I%20attempt%20to%20open%20Excel%20files%2C%20either%20from%20the%20desktop%20location%20or%20through%20the%20file%20explorer%2C%20Excel%20opens%20up%20as%20a%20blank%20file...%20like%20this%20screenshot%20below.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22AlexM2020_0-1620592848522.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279378i9154F667222C2744%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22AlexM2020_0-1620592848522.png%22%20alt%3D%22AlexM2020_0-1620592848522.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EI%20can%20open%20the%20file%20just%20fine%20when%20I%20start%20Excel%20first%20and%20then%20file%2Fopen%20or%20recent%20workbooks.%3C%2FP%3E%3CP%3EI%20resaved%20files%2C%20renamed%2C%20and%20even%20%22new%22%20files%20behave%20the%20same%20way.%20After%20some%20searching%2C%20I%20tried%20the%20trouble-shooting%20suggestions%20and%20reinstalled%20Office%20twice.%26nbsp%3B%20At%20a%20loss%20now...%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20help%20is%20greatly%20appreciated.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2339338%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339356%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20Not%20Displaying%20Sheets%20when%20Opening%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339356%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1049243%22%20target%3D%22_blank%22%3E%40AlexM2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20File%20%26gt%3B%20Options.%3C%2FP%3E%0A%3CP%3ESelect%20Advanced%20in%20the%20navigation%20pane%20on%20the%20left.%3C%2FP%3E%0A%3CP%3EScroll%20down%20to%20the%20General%20section.%3C%2FP%3E%0A%3CP%3EIf%20the%20check%20box%20'Ignore%20other%20applications%20that%20use%20Dynamic%20Data%20Exchange%20(DDE)'%20is%20ticked%2C%20clear%20it.%3C%2FP%3E%0A%3CP%3EClick%20OK.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2339359%22%20slang%3D%22en-US%22%3ERe%3A%20Workbook%20Not%20Displaying%20Sheets%20when%20Opening%20File%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2339359%22%20slang%3D%22en-US%22%3EThank%20you%20so%20much!%20It%20worked.%3CBR%20%2F%3EI%20am%20somewhat%20baffled%20tho%2C%20why%20this%20suddenly%20changed.%20It%20is%20not%20like%20that%20I%20updated%2F%20checked%20boxed%20in%20that%20section.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello Everyone, I am lost! 

 

For some reason, when I attempt to open Excel files, either from the desktop location or through the file explorer, Excel opens up as a blank file... like this screenshot below.  

AlexM2020_0-1620592848522.png

I can open the file just fine when I start Excel first and then file/open or recent workbooks.

I resaved files, renamed, and even "new" files behave the same way. After some searching, I tried the trouble-shooting suggestions and reinstalled Office twice.  At a loss now... 

Your help is greatly appreciated. 

 

 

 

 

 

3 Replies
best response confirmed by AlexM2020 (New Contributor)
Solution

@AlexM2020 

Select File > Options.

Select Advanced in the navigation pane on the left.

Scroll down to the General section.

If the check box 'Ignore other applications that use Dynamic Data Exchange (DDE)' is ticked, clear it.

Click OK.

Thank you so much! It worked.
I am somewhat baffled tho, why this suddenly changed. It is not like that I updated/ checked boxed in that section.

@AlexM2020 

Apparently a bit fell over. Perhaps cosmic radiation... <grin>