Share via

Power Query in Excel is not working

Anonymous
2024-05-05T06:27:41+00:00

Hello team,

I am trying to import data from web in excel.

Steps :

  1. Opened Excel.
  2. Clicked on DATA Tab.
  3. Cliecked on FROM WEB.
  4. Error : Power Query wasn't able to start. Restart Excel and try again.
  5. Tried re-installing Office but nothing worked.

Please guide to resolve the issue so that Power Query starts working and I will be able to fetch the data.

Thank you.

Microsoft 365 and Office | Excel | For home | Windows

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-05-05T07:38:20+00:00

    Hi, Nandkishor Chintanwar

    Welcome to Microsoft Community.

    I realize that you've encountered a problem with Excel and you can not start the Power Query function.

    According to your sharing, you have tried reinstalling and repairing the Office product but the issue has not been effectively mitigated.

    Therefore, this issue may be caused due to abnormal interference from your Excel app add-ins or third-party apps on your computer.

    Please follow the instructions below to temporarily disable the Excel add-ins, troubleshoot the third-party application and test if the problem can be temporarily fixed:

    1. Please open the Excel document, click "File" > "Options" > "Add-ins" button, adjust the "Manage" option at the bottom to "COM Add-ins". " option at the bottom to "COM Add-ins" (as shown below), click "Go" button. Please uncheck all the add-ons, and then test whether Power Query function can be restored to normal.

    1. If it still does not start, please uninstall the third-party security software or system optimization software installed in your computer (e.g., "360", "Tencent PC Butler", "Hot Fuzz", "Kaspersky", "LU Master", "Driver Genie", etc., if any). "360", "Tencent PC Butler", "Kaspersky", "LU Master", "Driver Genie", etc., if available). After successful uninstallation, please proceed to step 3 below. 3.
    2. Perform the steps in the Microsoft support article below, "clean boot" and restart your computer.

    Please refer to How to perform a clean boot in Windows - Microsoft Support.

    (Disclaimer: A “clean boot” starts Windows with a minimal set of drivers and startup programs. It helps to determine whether a background service is interfering with your game or program and to isolate the cause of a problem.    These steps of "clean boot" might look complicated at first glance. However, to avoid any trouble for you, please follow them in order and step-by step so that it will help you get back on track.)

    Please feel free to let me know how it goes.

    Best Regards,

    Cece | Microsoft Community Support Specialist

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments