How to Fix Power Query Display Issues Caused by Workday Office Connect
Question details
The user needs to fix a corrupted display and hidden Power Query pane in Excel 365 caused by a conflicting add-in.
- Product
- Microsoft Excel 365
- Device & OS
- not provided
- Scenario
- Attempting to use the Power Query editor while the Workday Office Connect COM add-in is installed.
- Observed behavior
- The Power Query pane becomes completely hidden or its visual display is corrupted, preventing the user from managing data queries.
Save your current workbook and ensure no background queries are actively refreshing before modifying your COM add-ins.
Disable the Workday Office Connect COM Add-in
Turn off the conflicting Workday Office Connect add-in to restore the Power Query pane's normal display and functionality.
COM add-ins can sometimes interfere with Excel's native UI rendering, specifically with advanced data tools like Power Query. Disabling the problematic add-in will quickly resolve the display corruption.
Launch Microsoft Excel. Click on 'File' in the top-left corner of the ribbon, then select 'Options' at the very bottom of the left-hand menu.
In the Excel Options dialog box, click on 'Add-ins' in the left pane. Look for the 'Manage' dropdown menu at the bottom of the window.
Select 'COM Add-ins' from the Manage dropdown list and click the 'Go...' button to open the COM Add-ins dialog box.
Locate 'Workday Office Connect' in the list of available add-ins. Clear the checkbox next to it, then click 'OK' to apply your changes.
Try WPS Office for a Stable and Conflict-Free Spreadsheet Experience
If third-party add-ins frequently crash your software or corrupt your spreadsheet displays, consider switching to WPS Office. It delivers a lightweight, streamlined environment for data management and analysis without the heavy resource load that causes add-in conflicts.
Frequently Asked Questions
Why does the Workday Office Connect add-in hide the Power Query pane?
Certain COM add-ins share memory and UI rendering tasks with Excel. If an add-in is outdated or poorly optimized for Excel 365, it can block or corrupt the graphical elements of the Power Query editor.
Can I use both Workday Office Connect and Power Query at the same time?
If they are conflicting on your current Excel build, you cannot use them simultaneously. You must temporarily disable the Workday add-in when editing queries until Workday releases a compatible update.
What should I do if disabling the add-in does not fix the Power Query display?
If the Power Query pane remains corrupted after disabling the add-in, try restarting Excel. If the problem persists, perform an 'Online Repair' of your Microsoft Office installation via the Windows Control Panel.
