'%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)
Fix Power Query Editor Not Opening in Excel 2019
Question details
The user is unable to open the Power Query Editor in an existing Excel 2019 workbook after a recent software update.
- Product
- Microsoft Excel 2019
- Device & OS
- not provided
- Scenario
- Attempting to edit an existing query by selecting Query > Edit in a previously saved workbook.
- Observed behavior
- The Power Query Editor fails to open in the existing workbook, although it functions correctly when tested in a brand-new workbook.
Before proceeding with an Office repair, save all open documents, completely close Microsoft Excel, and ensure your computer has a stable internet connection if an online repair is needed.
Perform a Microsoft Office Repair
Use the built-in Windows tool to repair your Office 2019 installation, which replaces missing or corrupted Power Query files caused by recent updates.
A recent Excel 2019 update may have inadvertently corrupted or removed configuration files essential for Power Query. Running the official Office repair utility is the most effective way to restore these missing components without losing your data or customized settings.
Click the Windows Start menu and select 'Settings' (the gear icon), then navigate to 'Apps' > 'Apps & features'.
Scroll down the list of installed applications until you find 'Microsoft Office 2019' or 'Microsoft 365'. Click on it and select 'Modify'.
In the dialog box that appears, select 'Online Repair' for a comprehensive fix (requires internet connection), or 'Quick Repair' for a faster, offline scan. Click the 'Repair' button.
Once the repair process completes, restart your computer. Open Excel 2019, load your existing workbook, and try opening the Power Query Editor again.
Try WPS Office for Seamless Data Management
Tired of dealing with update bugs and corrupted installations in Microsoft Excel? WPS Office provides a lightweight, highly compatible, and free alternative for your daily spreadsheet and data analysis needs.
- 1. Download the Installer: Visit the official WPS Office website and click the 'Free Download' button.
- 2. Install WPS Office: Run the downloaded executable file and follow the straightforward on-screen instructions to install the software.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheet and open your existing .xlsx files to instantly resume your work with full compatibility.
Frequently Asked Questions
Why does Power Query work in a new workbook but not my existing one?
Update corruptions often affect the cached data connections or background query metadata tied to a specific file. A new workbook creates a fresh set of background connections, which temporarily bypasses the corrupted cache of the older file.
Will repairing Microsoft Office delete my personal Excel files?
No. The Office repair tool only scans and replaces application files, registry keys, and software configurations. Your personal workbooks, documents, and data will remain completely untouched.
What if the Office repair does not fix the Power Query Editor?
If repairing doesn't work, ensure your Windows OS is fully updated. You can also try rolling back Microsoft Office to a previous version before the update occurred, or completely uninstalling and reinstalling Office 2019.
