Power Query Problems

How to Fix Missing Google Sheets Columns in Excel Power Query

Kushani Nimanthika Sep 27, 2026 870 views

Question details

The user needs to resolve an error where Excel Power Query fails to find specific columns, such as Comment or Time Zone, after a new column is added to the source Google Sheet.

How to Fix a Missing Google Sheets Column in Excel Power Query

Product: Microsoft Excel
Device & OS: not provided
Scenario: A user inserts a new column into a Google Sheet connected to Excel, but upon refreshing, Power Query throws an error stating that a specific column cannot be found.
Observed behavior: Excel Power Query does not automatically detect the new column structure and displays an error indicating that previously existing columns (e.g., Comment or Time Zone) are missing from the data source.

Before you start

Ensure that your Google Sheet has completely synced online and that there are no merged cells in your header row before refreshing the connection in Excel.

Solution 1Recommended

Create a New Data Connection

Establishing a fresh connection in a new workbook can bypass cached schema issues and instantly recognize the updated column layout.

When structural changes are made to a source file, Excel sometimes retains the old column mapping in its query cache. Building a new connection ensures that Power Query fetches the latest schema directly from Google Sheets.

Verify Google Sheets Headers

Open your Google Sheet and ensure that the header row is completely consistent. Every column must have a unique name, and there should be no unexpected blank headers.

Open a New Workbook

Launch Microsoft Excel and create a completely new, blank workbook to prevent interference from older query steps.

Establish a New Connection

Navigate to the Data tab, click on 'Get Data', select 'From Web' (or your preferred Google Sheets connection method), and paste the link to your updated Google Sheet.

Load and Verify

Click 'Transform Data' to open the Power Query Editor. Check if the newly inserted Time Zone column and the existing Comment column are now successfully detected.

Header Formatting Tip: Make sure your Google Sheets column names do not contain hidden trailing spaces, as Power Query treats 'Time Zone ' differently from 'Time Zone'.

Solution 2

Remove Hardcoded Steps in Power Query Editor

Edit the existing query to remove static column references that break when new columns are inserted.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet Management

If complex data connection errors and query setups in Microsoft Excel are slowing you down, consider switching to WPS Office. It provides a highly compatible, free, and lightweight alternative for everyday spreadsheet processing without the steep learning curve.

1. Download and Install: Get WPS Office for free from the official website and install it on your device in minutes.
2. Open Your Spreadsheets: Launch WPS Spreadsheets and seamlessly open your existing Excel workbooks without losing any formatting.
3. Analyze Data Easily: Use intuitive data processing features to filter, sort, and analyze your datasets without relying on overly complex query engines.

Fully compatible with Microsoft Excel (.xlsx, .xls) formatsLightweight installation and incredibly fast startup timesFamiliar user interface that requires no retrainingFree to use with comprehensive built-in data analysis tools

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query say my column cannot be found after I added one in Google Sheets?

This happens because Power Query often generates steps (like 'Changed Type') that hardcode the original column names and their exact order. When you insert a new column, the expected layout changes, causing the static query references to fail.

Does adding a new column to Google Sheets automatically update in Excel Power Query?

No, changes made in Google Sheets are not instantly pushed to Excel. You must manually refresh the data connection in Excel by navigating to the Data tab and clicking 'Refresh All'. Even then, structural changes may require editing the query.

How can I prevent missing column errors in the future?

To prevent these errors, avoid hardcoding column names in your query. Delete the automatic 'Changed Type' step if you frequently add or remove columns, or select columns dynamically by index rather than by name in the Advanced Editor.

Excel & Data Problems