Why New Rows Disappear from an Excel Table After Refresh
Question details
The user needs to keep a manually added row in an Excel table after refreshing it.

- 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.
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.
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.
Open Data > Queries & Connections, find the query for the table, and right-click it and select Edit.
In Power Query Editor, select the Source step under Applied Steps to identify the source file, table, or connection.
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.
Review Applied Steps in Power Query Editor for filters or other transformations that might exclude the new row, and adjust them if needed.
Select Home > Close & Load, then use Data > Refresh All if needed. Check that the new row appears in the output table.

Create a static copy of the query results
Use a separate copy when you want to edit the data without future query refreshes overwriting it.
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.

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.




