Powerquery in Excel - Load to Worksheet failed

When I try to load my query to an excel worksheet, I end up with an error.

Error shows; "Microsoft Excel couldn't load a necessary component. It might have been damaged or deleted. Try reinstalling the client software or data source driver software for your database."

I cannot find any solution to this issue. Please assist. Thank you.

I was finally able to resolve the issue after 2 months of trial and error, searching the web for anything that could work.

1. I attempted to recreate the steps in a new profile I created on my laptop, and the same issue occurred.
2. I attempted to recreate the steps on a different laptop, and it worked. So the issue has to be the laptop.
3. I opened CMD as admin and ran the following commands consecutively;

• chkdsk /f /r /x (restarted computer so it could do the check when coming back on)
• sfc /scannow
• DISM.exe /Online /Cleanup-image /Restorehealth

4. Then, I restarted the laptop. It started working.

Hope this helps someone out there. I almost lost my mind trying to figure out the problem.

Turns out it was a hardware issue, not an application issue.

Thanks for your help, It's useful.

sfc /scannow

I think it's solved the problem.

Dear Susan,

Thanks for your updates and sorry for the late reply.

From your description, it seems that the data source only fails to be loaded in your Excel application.

As the data source is a normal Excel sheet, could you save it in another local folder and then re-load it in a newly created Excel file to see and let us know the result?

If you save the Excel file as a new file and then load it again, what's the result?

Thanks for your effort and time!

Sincerely,

Cliff | Microsoft Community Moderator

Hi Cliff,

Thank you for your response. The answers to your questions are below.

1. A normal excel sheet.
2. Yes, I can open the data source.
3. This is the first time for me to load the query, but the query can be loaded by others.

I am finding it difficult uploading pictures. It keeps failing.

I copied the Excel Version number, Version 2212 (Build 15928.20282 Click-to-Run) / Monthly Enterprise Channel.

I checked for updates and it's up to date. If you need any more information, let me know.

Dear Susan,

What data source do you load when using Power Query, a normal Excel sheet or other sources? If you load from other sources in the Excel file, what's the result?

Can you open and use the data source successfully in your environment?

Could you load the query before? Does the issue happen suddenly? If yes, what did you before the issue occurred?

Please first check whether you are using the latest version number of the Excel application. If no, I suggest you update the version number, restart the computer and then do a test to see the result.

Update history for Microsoft 365 Apps (listed by date) - Office release notes | Microsoft Learn

Meanwhile, I'd like you to open Excel>click on File>Account and upload a full screenshot of the Account page for our reference.

Note: Remove any private information before uploading the screenshots.

Thanks for your effort and time!

Sincerely,

Cliff | Microsoft Community Moderator