Why an Excel Table Changes After Refreshing in WPS Office
Question details
The user needs to understand why an Excel table changes position, size, or content after a refresh, especially after adding a column beside or to the left of the table.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with an Excel table connected to an external data source or Power Query and adds a column next to or left of the table before refreshing.
- Observed behavior
- After refreshing, the table may shift, expand or shrink, include or exclude the adjacent column, or overwrite nearby cells depending on the query output and table settings.
Before troubleshooting, note the refresh method (right-click refresh, Data tab refresh, or Power Query connection), the table name, and whether the added column is inside the table or outside the adjacent area. Keep the workbook open where the column is visible before and after the refresh so you can compare the table range.
Check whether the added column is inside the Excel table or outside the query output range
Use this first to distinguish a table formatting issue from a query destination issue.
Open the workbook in WPS Office Spreadsheets and click any cell inside the Excel table.
Go to the Table Tools tab and note the table name and range shown in the Name Box or table properties.
Check whether the added column header appears inside the highlighted table range or sits outside it. If it is outside, the refresh may not include it.
Verify the Power Query or external connection output range before refreshing
Use this if the table is created by a query and the refresh overwrites or moves adjacent cells.
Reassign the query output to the correct table range
Use this when refresh consistently places data in the wrong range or drops the adjacent column.
Use WPS Office as a Free Microsoft Office Alternative for Everyday Spreadsheet Editing
The underlying refresh behavior is controlled by the Excel/Power Query definition in Microsoft Office. WPS Office does not modify that query definition, but it offers a free, lightweight, familiar spreadsheet environment to open, inspect, and edit Excel workbooks without replacing your Office workflow.
Frequently Asked Questions
How can I tell if a column is part of the Excel table before refreshing?
Click a cell inside the table and look at the highlighted table range in WPS Spreadsheets. If the new column header is inside the highlighted border and shows a filter arrow, it is part of the table; if not, it is outside.
Why does the table expand and overwrite the column to the left after refresh?
Usually the query destination is set to a fixed range or the table's external data range expands to include adjacent cells. Check the connection destination in the Data tab > Connections, then set it to the exact table range.
Does WPS Office support Power Query refresh?
WPS Office can open and refresh many Excel-compatible workbook connections, but full Power Query editor features may be limited. For advanced Power Query definitions, edit them in Microsoft Excel, then continue working in WPS Office.
Will converting the table to a range stop the refresh from moving it?
Converting to a range removes table and query-linked behavior. If you need the query to refresh into a fixed location, adjust the query destination instead of converting the table.
