Power Query Problems

Why New Rows Disappear from an Excel Table After Refresh

Amos GikundaAmos Gikunda Nov 18, 2026 869 views

Question details

The user needs to keep a manually added row in an Excel table after refreshing it.

Why New Rows Disappear from an Excel Table After Refresh
Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Adding a row to an Excel table that may be loaded from a query or external connection.
Observed behavior
The manually added row disappears when the table is refreshed.
Before you start

Select a cell in the affected table and check Data > Queries & Connections to see whether it is linked to a query. If it is, identify the source before deciding where to add the row.

Solution 1Recommended

Add the new row to the query's source data

Use this method to keep the table connected and include the row in future refreshes.

A query output is rebuilt from its source and applied steps during refresh. A row typed directly into the output may therefore be overwritten.

1
Inspect the query

Open Data > Queries & Connections, find the query for the table, and right-click it and select Edit.

2
Identify the source

In Power Query Editor, select the Source step under Applied Steps to identify the source file, table, or connection.

3
Add the row at the source

Open the source table or file and add the row there. If the query uses an editable entered-data step, edit that step in Power Query instead.

4
Check the query steps

Review Applied Steps in Power Query Editor for filters or other transformations that might exclude the new row, and adjust them if needed.

5
Refresh the result

Select Home > Close & Load, then use Data > Refresh All if needed. Check that the new row appears in the output table.

Add the new row to the query's source data
Free Microsoft Office alternative

Edit Static Spreadsheet Tables in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and work with editable tables as part of a straightforward move from Microsoft Office.

Edit and add rows to static spreadsheet tables.Open and save compatible Microsoft Excel XLSX and XLS files.Use a familiar interface for everyday spreadsheet work.Move between compatible Office files with a lightweight application.
microsoft office alternative - wps office

Frequently Asked Questions

Why does refresh remove a row I typed into my table?

If the table is query output, refresh rebuilds it from the source data and query steps. A row entered directly into the output is not necessarily part of that source.

How can I tell whether a table comes from Power Query?

Select the table and open Data > Queries & Connections. Look for a query associated with the table, then right-click it and select Edit to inspect its source.

Why is my new source row still missing after refresh?

Open the query from Data > Queries & Connections and review Applied Steps in Power Query Editor. A filter or another transformation may exclude the row, or the source range may not include it.

Can I keep the results without a connection?

Yes. Copy the results to a blank area using Home > Paste > Values, then select the pasted range and choose Insert > Table. The copy is editable but will not update with the original query.