Share via

Excel Crash when Refresh Data

Anonymous
2024-08-06T13:09:14+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.

PS : I have tried multiple times to add screenshot but I have an error message (fail to import)

Best regards,

***Moved from Microsoft 365 and Office / Excel / For business / Windows***

Microsoft 365 and Office | Install, redeem, activate | Other | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-08-07T12:41:40+00:00

    Hi Aiden,

    Thanks for your reply. I just posted the question on the link you provided.

    Best regards,

    Was this answer helpful?

    0 comments
  2. Anonymous
    2024-08-07T11:49:33+00:00

    Hi, Charlotte JAGO

    Thank you for using Microsoft products and posting them in the community.

    I wish I could help you with your question, however, your question seems to require more professional support, I suggest you try to seek help in Microsoft Learn, where there are more experts in related fields who can provide you with better solutions.

    You can click "Ask a question" and there are experts who can provide more professional solutions.

    Here is a link to the forum where you can raise specific situations and share your ideas to help solve the problem.

    Excel - Microsoft Q&A（English only）

    Sincerely hope that your question can be properly handled after contacting the right department. Thank you for your understanding!

    If you need further help, please feel free to reply.

    Thank you for your understanding and patience, I look forward to your reply.

    Aiden.C - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments