Excel Crash when Refresh Data

Charlotte JAGO 0 Reputation points
2024-08-07T12:40:16.6266667+00:00

Hi,

Microsoft Excel 2016 (16.0.5448.1000) MSO (16.0.5456.1000) 64 bits

I have an Excel with a connexion to an Oracle Database (Provider=OraOLEDB) that crashes when I try to update it.

The command is a SQL Query that works fine when tried elsewhere and provides about 26k lines and 14 columns.

I have already checked the custom add-ins installed in Excel, click File > Options > Add-Ins. At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go. Clear the checkbox for any enabled COM add-ins. select OK. => Nothing was checked

I have already checked the cache and I cleared it.

I have already recreated the datasource from scratch and the result is the same.

I have other files like that on various database and they work just fine. I don't understant why this one isn't working. No error message, just shuts down.

I've asked the question here and Aiden.C - MSFT asked me to post it here.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_other-msoffice_unknown-mso_unsupported/excel-crash-when-refresh-data/71dbbbdc-1201-491b-9067-1b28bc8f48aa?messageId=5c76f93b-ca8e-42f6-bc6d-5ed0c7e29975

Best regards,

Microsoft 365 and Office Excel For business Windows
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 30,046 Reputation points Microsoft External Staff
    2024-08-08T05:49:14.22+00:00

    Hi,

    You can try to check the Oracle Client Configuration: Ensure that the Oracle client is correctly configured and that there are no issues with the Oracle OLEDB provider.

    Then "Disable Hardware Acceleration": Go to File- Options- Advanced, scroll down to the Display section, and check the box for “Disable hardware graphics acceleration".

    And enable "Ignore other applications that use Dynamic Data Exchange (DDE)": Go to File- Options- Advanced- scroll down to the General section, check the box for "Ignore other applications that use Dynamic Data Exchange (DDE)".

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.


    If the response 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.


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.