Problem opening spreadsheets in Excel 2016 since Win 11 24H2 upgrade

Alan Lee 0 Reputation points
2024-11-22T11:11:37.2566667+00:00

We have just updated to Win 11 24H2 and use stand alone Office 2016 Standard. We are experiencing problems with opening Excel spreadsheets from hyperlinks and File Explorer where a ~$ temp file pre-exists against the file we are trying to open. Excel stops at Loading 0% and never completes the action - only recourse is to End Task on Excel in Task Manager. If Excel is already open then things work fine.

File association is fine; testing an old machine still at Win 11 22H2 shows no such problems.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,990 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,021 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Jacen Wang 965 Reputation points Microsoft Vendor
    2024-11-22T17:28:18.89+00:00

    Hello,

    Thank you for posting in the Microsoft Community forum.

    You can try the following steps to troubleshoot the problem:

    1. Make sure Office 2016 is fully updated.
    2. Try to disable all Excel add-ons. You can do this in the following ways:

    Open Excel. Go to: File > Options > Add-Ins.

    At the bottom of the window, make sure the Manage: COM plug-ins is selected, and then click Start.

    Deselect all plug-ins and click OK.

    1. Dynamic Data Interchange (DDE) sometimes causes problems opening Excel files. Try disabling "Enable Dynamic Data Exchange Server Lookup" to test.

    This option is located in the Excel Trust Center (Trust Center > File > Options > Trust Center Settings > External Content).

     

    Reference:

    Security settings for Dynamic Data Exchange in Excel Trust Center - Microsoft 365 Apps | Microsoft Learn

    I hope this helps.

    Best regards

    Jacen

    ——————————————————————————————————

    If the Answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.