'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Power Query Could Not Start Issue in Excel
Question details
The user is unable to launch Power Query in Microsoft Excel even after repairing or reinstalling Microsoft 365, and needs to identify the root cause.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Launching Power Query to manage, clean, or transform spreadsheet data.
- Observed behavior
- Power Query fails to start, potentially resulting in a blank screen, error message, or unresponsiveness.
Before proceeding with advanced troubleshooting, ensure your Windows operating system is fully up to date and temporarily disable any third-party Excel COM add-ins that might be interfering with Power Query.
Gather Error Details and Verify Office Version
Documenting the exact error message and checking your Office update channel is the most critical first step to diagnosing Power Query startup failures.
Since reinstalling Office does not always fix deep-rooted Power Query issues, pinpointing the exact failure symptom is essential. Microsoft 365 provides detailed build information that helps isolate compatibility bugs.
Take a screenshot or write down any specific error code, warning message, or blank-screen behavior that appears immediately when you click 'Get Data' or try to launch the Power Query Editor.
Open Excel, click on the 'File' tab in the top-left corner of the ribbon, and select 'Account' from the bottom of the left-hand menu.
Look under the 'Product Information' section. Document your exact installed Office Version, Build number, and the specific Update Channel (e.g., Current Channel or Semi-Annual Enterprise Channel).
Click the 'Update Options' button next to your version info and select 'Update Now' to ensure your installation isn't missing a recent patch that fixes Power Query bugs.
Perform an Online Repair of Microsoft Office
If updating Excel does not work, the core installation files required for Power Query may be corrupted and require an online repair.
Try WPS Office for Seamless Data Processing
If Microsoft Excel continues to experience crashing issues or startup failures with complex tools, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative for managing spreadsheets and analyzing data without heavy system requirements.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button to get the setup file.
- 2. Install WPS Office: Run the downloaded installer and follow the quick on-screen instructions to set up the suite on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your existing Excel workbooks to continue your data analysis without interruptions.
Frequently Asked Questions
Why is my Power Query showing a blank screen when it starts?
A blank screen in Power Query is often caused by outdated graphics drivers, conflicting Excel add-ins, or corrupted Microsoft Edge WebView2 runtime components, which modern versions of Power Query rely on to render the user interface.
Will reinstalling Microsoft 365 fix all Power Query issues?
Not necessarily. If the issue stems from corrupted Windows registry keys, conflicting third-party software, or a specific bug in your current Office Update Channel, simply reinstalling Microsoft 365 may not resolve the startup failure. Documenting exact error codes is a more reliable way to find a solution.
How do I check if Power Query is disabled in Excel?
In modern Excel versions, Power Query is built-in under the 'Data' tab. If the 'Get Data' buttons are missing or unresponsive, navigate to File > Options > Add-ins. Manage 'COM Add-ins' and ensure that the 'Microsoft Power Query for Excel' add-in (if listed) is checked and not disabled.
