How to Fix Blank Excel Screens for SQL Server Data Connections
Question details
The user needs to fix an issue where attempting to connect to a SQL Server database results in a blank table-selection screen and an empty Queries & Connections pane.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Importing data into a spreadsheet from an external SQL Server database using the Get Data feature.
- Observed behavior
- The table-selection screen appears completely blank, and no active connections are displayed in the Queries & Connections pane.
Ensure you have the correct database credentials and a stable network connection to the SQL Server before modifying application settings.
Isolate Add-in Conflicts Using Safe Mode
Starting the application in Safe Mode bypasses installed add-ins, helping identify if a third-party plugin is causing the blank connection screen.
Third-party COM add-ins, such as SQL Spreads, can sometimes conflict with native data connection interfaces. Using Safe Mode temporarily disables these components to verify the root cause.
Press the Windows key + R to open the Run dialog. Type 'excel /safe' and press Enter to launch the application.
Navigate to Data > Get Data > From Database > From SQL Server Database and verify if the table-selection screen loads correctly.
If the screen displays properly in Safe Mode, go to File > Options > Add-ins. Select 'COM Add-ins' from the Manage drop-down menu and click Go.
Uncheck the active add-ins (especially database-related ones like SQL Spreads) one by one, restarting normally each time to pinpoint the exact conflict.
Perform an Online Office Repair
If Safe Mode does not resolve the issue, repairing the installation can fix corrupted application files causing database connection failures.
Experience Stable Data Management with WPS Office
If you frequently encounter blank screens, add-in conflicts, or slow performance when handling data connections in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that easily handles your data without the heavy overhead of conflicting plugins.
Frequently Asked Questions
Why does the 'Get Data' screen show up blank?
This is typically caused by incompatible third-party COM add-ins interfering with the data query interface. It can also happen if the application's background files are corrupted and require an online repair.
How do I check if background software is causing the blank screen?
You can perform a Windows clean boot by opening the System Configuration tool (msconfig), hiding all Microsoft services, and disabling remaining third-party startup items. Restart your computer to see if the issue persists.
What should I do if disabling add-ins doesn't work?
If disabling add-ins and running an online repair do not work, try testing a completely new workbook to rule out file-specific corruption, or check if other types of data connections (like web or text imports) are functioning properly.
