Fix Excel Table Formulas Not Auto-Filling New Rows in WPS Spreadsheets
Question details
The user needs to restore automatic formula filling in an Excel table column so new rows from Microsoft Forms continue to receive the calculated column formula.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user manages an Excel table connected to Microsoft Forms and expects new response rows to inherit the calculated column formula.
- Observed behavior
- New rows are added, but the formula column does not fill automatically. The calculated column may have lost its consistent table formula configuration.
Open the workbook in WPS Spreadsheets and make sure the worksheet is not protected. Click a cell inside the response range and check whether the Table Tools tab appears so you know if the range is still a real Excel table.
Restore the calculated column in a real Excel table
Use this first when a formula column has lost its table formula configuration and new rows stop filling.
WPS Spreadsheets treats an Excel table as a structured range. A calculated column auto-fills only when the entire column contains one consistent formula and the table object is intact.
Open the affected workbook in WPS Spreadsheets, then click any cell inside the response range. If the Table Tools tab appears, the range is still a table; if not, select the range, click Insert > Table, and enable My table has headers.
Click a cell in the formula column and look at the formula bar. Confirm the entire column uses one consistent formula, such as =[@Price]*[@Qty], rather than mixed values or hard-coded results.
If the formula is inconsistent, select all data cells in the calculated column, press Delete to clear them, then type the formula once in the first data row and press Enter. Confirm the prompt to overwrite the calculated column formula.
Go to Formulas > Calculation Options and select Automatic so WPS Spreadsheets recalculates and fills the column when new rows are added.
Add a new row directly below the table or insert a table row, then confirm the formula appears automatically. If the workbook is linked to Microsoft Forms, submit a test response and refresh the workbook.
Convert the response range back into a table
Use this if the response range was converted from a table to a normal range and no longer auto-fills formulas.
Set calculation options to Automatic
Use this when the formula does not update after new rows because calculation is set to Manual.
Repair Excel Table Calculated Columns in WPS Spreadsheets
Open the affected workbook in WPS Spreadsheets, restore the table's calculated column, and enable Automatic calculation so new rows fill formulas correctly.
- 1. Download and install WPS Office: Get WPS Office from the official WPS site, then open WPS Spreadsheets.
- 2. Open the affected Excel workbook: Click Menu > Open and select the .xlsx workbook that contains the Microsoft Forms response table.
- 3. Verify the table and calculated column: Click inside the response range, check Table Tools, and re-enter one consistent formula in the calculated column if needed.
- 4. Enable Automatic calculation: Go to Formulas > Calculation Options and select Automatic.
- 5. Test new response rows: Add a test row or refresh the Forms-connected workbook to confirm the formula fills automatically.
Frequently Asked Questions
Why does my Excel table formula not fill down when Microsoft Forms adds a new row?
Usually the calculated column has been overwritten with mixed formulas or the range is no longer a genuine Excel table. Open the workbook in WPS Spreadsheets, check for the Table Tools tab, and re-enter one consistent formula in the first data row to restore the calculated column.
How do I confirm my data range is still an Excel table in WPS Spreadsheets?
Click any cell in the range. If the Table Tools tab appears on the ribbon and the range shows table styling, it is still a table. If not, select the range, click Insert > Table, and enable My table has headers.
Can WPS Spreadsheets use structured table references like =[@Column]?
Yes. WPS Spreadsheets supports Excel .xlsx table objects and structured references, so calculated columns can use formulas such as =[@Price]*[@Qty].
What should I do after recreating the formula column?
After entering the formula once in the first data row and confirming the calculated column prompt, set Formulas > Calculation Options to Automatic, then add a test row or refresh the Forms-connected workbook to verify it fills.
Does the fix work if the workbook comes from Microsoft Forms?
You can repair the table and formula column in WPS Spreadsheets, but the live Microsoft Forms connection must be refreshed through your Microsoft account or Microsoft Excel to receive new submissions.
