Software⏱️ 3 min read📅 2026-06-15

How to Fix: Error is using Microsoft Query data in excel in 3rd Person's PC

Error using Microsoft Query data in Excel on another PC, unable to refresh data without selecting new data source.

Quick Answer: Check if the Microsoft Query connection is specific to the creator's PC and try re-creating the connection or using a different method to access the SQL Server.

📋 Table of Contents

  1. 🛑 Root Causes of the Error
  2. 🚀 How to Resolve This Issue
  3. 💡 Conclusion

Error using Microsoft Query data in Excel on a third-party PC is causing frustration. The issue arises when trying to refresh data from a SQL Server connection, resulting in a new 'Select Data Source' window appearing instead of automatically refreshing the data.

This problem can be particularly vexing for users who are accustomed to seamless data refreshes with SQL Server connections. However, using Microsoft Query Data Connections introduces an additional layer of complexity that must be addressed.

🛑 Root Causes of the Error

  • The primary reason for this error is that Microsoft Query Data Connections do not inherit the same connection settings as SQL Server connections. When a user creates a data connection through Microsoft Query, it generates a new connection string that may not be recognized by other users' systems.
  • An alternative explanation is that the issue might be related to the specific version of Excel or Office being used on the third-party PC. It's possible that newer versions have updated features or compatibility issues with older data connections.

🚀 How to Resolve This Issue

Configuring Connection Settings

  1. Step 1: Step 1: Ensure that the connection string generated by Microsoft Query is correct and matches the SQL Server connection settings used on the original system. You can do this by comparing the connection strings in both systems.
  2. Step 2: Step 2: Update the Excel file to use a compatible version of Office, if possible. This may involve reinstalling or upgrading to a newer version of Excel or Office.
  3. Step 3: Step 3: If using an older version of Excel, try updating the data connection settings manually by going to 'File' > 'Options' > 'Add-ins' and ensuring that the Microsoft Query add-in is enabled.

Using a Compatibility Mode

  1. Step 1: Step 1: Enable compatibility mode in Excel by going to 'File' > 'Options' > 'Advanced' and checking the box next to 'Compatibility mode'. Select the version of Office that matches the original system's settings.
  2. Step 2: Step 2: If using an older version of Excel, try updating the data connection settings manually by going to 'Data' > 'Connect to Query' and selecting the correct connection string from the list of available options.

💡 Conclusion

By following these steps, users should be able to resolve the issue with Microsoft Query Data Connections in Excel. Remember to always verify connection strings and ensure compatibility modes are enabled when working with data connections.

Did this fix your problem?

If not, try searching for specific error codes.

🔍 Search Error Database

❓ Frequently Asked Questions

🛠️ Related Fixes

How to Fix: Pc crashes shortly after launching game (rainbow

Fix Pc crashes shortly after launching game (rainbow six siege). Compl

How to Fix: Installing an APK on a locked down phone

Installing an APK on a locked down phone: Try using a rooted device, e

How to Fix: New PC build- no signal and no clue

Fix New PC build- no signal and no clue. Complete troubleshooting guid