question

RichMorrissey-0103 avatar image
0 Votes"
RichMorrissey-0103 asked emilyhua-msft commented

Excel files not opening after double ckicking

We are seeing something odd in our company now. Most PC's are not opening Excel files when double clicking on them. Excel launches but to a blank form. You can then use File--> open to open the file. this seems to be affecting most (but not all PC's here). Also there are some reports of TextPad having the same issue, leave me wondering if it is not an Office issue, but Windows. All the clients are Windows 10 and Excel 2016. We've gone through articles we can find on the internet including this one. This issue just began in th elast week or so. All PC's are completely patched with the July 2021 patches.

windows-10-generaloffice-excel-itpro
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered

@RichMorrissey-0103

Could you please share us what are formats of Excel workbooks opened as blank? Such as .xlsx files or other formats.

From Office perspective, I would provide following suggestions to have a check.

  • Go to Excel > File > Options > Advanced > Scroll down to General section, check whether "Ignore other applications that use Dynamic Data Exchange (DDE)" is ticked.

  • Go to Registry Edirtor, locate to HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open\command, I would suggest you backup the entry "command" first. (Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.)
    Then please try to add "%1" in "(Default)" data value to check this issue, such as "C:\Program Files\Microsoft Office\Root\Office16\EXCEL.EXE" "%1"
    118499-image.png

  • If the steps above do not work, please perform Repair for Office 2016 from Control Panel.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


image.png (37.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RichMorrissey-0103 avatar image
0 Votes"
RichMorrissey-0103 answered

I've only seen the issue with .xlsx file so far, since that is all we've used for years.

We have already tried both of those suggestions without any luck.

Thanks for the suggestions!

Rich

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RichMorrissey-0103 avatar image
0 Votes"
RichMorrissey-0103 answered emilyhua-msft commented

I just tried with a .csv file and got the same result.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.