Power Query Problems

Fix Grayed-Out Edit Query in Excel Connection Properties

Steve K Sep 30, 2026 868 views

Question details

The user needs to change a server name for an external data connection, but the Edit Query option is unavailable in the Excel connection properties.

How to Fix a Grayed-Out Edit Query in Excel Connection Properties

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to update the server name or modify queries for an IQY file or external data connection.
Observed behavior: The Edit Query button in the Connection Properties dialog box is grayed out and cannot be clicked.

Before you start

Ensure that your Excel workbook is not protected, as worksheet or workbook protection can disable connection editing features. Additionally, verify that you have network access to the original server or data source.

Solution 1Recommended

Verify Data Import Source and Connection Type

The Edit Query option is only available for data imported via Power Query. Check your connection type to understand why the option is disabled.

Excel handles different data sources in varying ways. If your data was imported from a legacy IQY file, a standard web query, or another basic workbook connection, the Power Query Editor is not used, which causes the 'Edit Query' button to be grayed out.

Open Queries & Connections

Navigate to the 'Data' tab on the Excel ribbon and click on 'Queries & Connections' to open the side panel.

Access Connection Properties

Right-click on the problematic connection in the list and select 'Properties' from the context menu.

Check the Definition Tab

Click on the 'Definition' tab. Look at the 'Connection type' field. If it says 'Web Query' or 'Office Data Connection' instead of 'Power Query', the Edit Query button will naturally be unavailable.

Verify Data Import Source and Connection Type

Legacy Connections: For legacy IQY files, you cannot use Edit Query. You must either edit the connection string manually or recreate the import using 'Get Data' (Power Query).

Solution 2

Edit the Connection String Directly

If you only need to change the server name and Edit Query is unavailable, you may be able to modify the connection string directly.

Solution 3

Consult Specialized Technical Communities

Since external queries and server configurations can involve complex credentials or network setups, seeking expert advice is recommended for persistent issues.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If you frequently encounter complex configuration issues in Microsoft Excel, consider WPS Office. It provides a lightweight, highly compatible, and user-friendly spreadsheet environment that makes data management straightforward without the bloat.

1. Download the Installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the downloaded installer and follow the quick on-screen instructions to set up the software.
3. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing Excel workbook to continue managing your data seamlessly.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsFree, lightweight, and fast to install on any operating systemIntuitive interface that feels familiar, ensuring a zero-learning-curve migrationBuilt-in robust tools for data analysis and basic external data connections

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Edit Query button grayed out for my IQY file?

IQY (Internet Query) files are legacy web queries in Excel. They do not utilize the modern Power Query Editor, which is why the 'Edit Query' option is disabled for these specific connection types.

How can I change the server name if Edit Query is unavailable?

You can change the server name by going to the 'Definition' tab in Connection Properties and manually editing the 'Connection string' or 'Command text' fields. Alternatively, you can recreate the connection from scratch using the 'Get Data' feature.

Does workbook protection affect data connections?

Yes. If the workbook or worksheet is protected, Excel may lock structural changes, which can result in grayed-out buttons across the Data tab, including connection properties and query editing options.

Excel & Data Problems