How to Fix Microsoft Query Data Source Window Cut Off in Excel
Question details
The user is unable to view or interact with the full Microsoft Query data source selection dialog because the window is cut off or truncated.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Attempting to select a data source using Microsoft Query in Excel.
- Observed behavior
- The data source window is truncated, hiding parts of the list or controls, making it impossible to select the desired data source.
Before troubleshooting, ensure you have saved your current Excel workbook and take note of your exact Excel version from the File > Account menu.
Run Excel in Safe Mode to Disable Add-ins
Starting Excel in Safe Mode helps determine if a third-party add-in is causing the dialog box to truncate.
Sometimes, incompatible add-ins can interfere with older legacy dialog boxes in Excel. Safe Mode bypasses all add-ins and custom toolbar settings.
Press the Windows key + R on your keyboard to open the Run dialog box.
Type 'excel /safe' in the Run box and press Enter or click OK.
Open your workbook and launch Microsoft Query to see if the window displays correctly. If the window is no longer cut off, an add-in is the culprit and should be disabled from File > Options > Add-ins.
Adjust Windows Display Scaling and Resolution
High DPI settings or custom display scaling can sometimes cause older dialog boxes like Microsoft Query to render incorrectly.
Perform an Office Online Repair
If the issue persists in Safe Mode and with default scaling, repairing the Office installation can fix corrupted system files causing UI glitches.
Try WPS Office for Seamless Data Management
If you are tired of dealing with legacy dialog glitches like the Microsoft Query window being cut off, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling complex spreadsheets without UI rendering bugs.
Frequently Asked Questions
Why does the Microsoft Query window get cut off in Excel?
This issue is most commonly caused by incompatible third-party add-ins, incorrect Windows display scaling settings (especially on high-resolution monitors), or corrupted Office installation files.
How do I check my exact Excel version for troubleshooting?
Open Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom left menu. Your version, build number, and update channel will be clearly displayed under the 'About Excel' section.
Will an Office Quick Repair fix UI truncation issues?
A Quick Repair might resolve minor configuration issues without needing an internet connection. However, for stubborn UI bugs like a cut-off dialog box, an Online Repair is highly recommended as it completely verifies and reinstalls the application files.
Can a dual-monitor setup cause Excel dialog boxes to render incorrectly?
Yes, dragging an older Excel dialog box between monitors with drastically different scaling percentages (e.g., 100% on one and 150% on the other) can sometimes cause the window to truncate. Setting both monitors to the same scaling can serve as a temporary workaround.
