Fix Array Formulas Blocking Table Expansion in Excel Online
Question details
The user needs to expand an Excel table when an array formula interferes with adding rows in Excel Online.

- Product
- Microsoft Excel Online
- Device & OS
- not provided
- Scenario
- Adding rows to a table in a workbook that contains an array formula.
- Observed behavior
- The table may not expand correctly when new rows are added.
Locate the table and the array formula or spill range near the rows you want to add. Check whether the formula needs to return multiple cells or can be calculated separately for each table row.
Adjust the array formula and table in Excel desktop
Use the desktop app to inspect and modify array formulas that are difficult to manage in Excel Online.
In Excel Online, choose Open in Desktop App from the workbook's editing or opening options.
Select the cells containing the array formula and check whether its range overlaps the area where the table needs to expand.
Move or revise the array formula so its output does not overlap the table's expansion area. For a legacy multi-cell array formula, select the entire array range before modifying it.
Add the new rows to the table in Excel desktop, save the workbook, and reopen it in Excel Online to check the result.

Replace the array formula with a row-by-row formula
Use this approach when each table row can be calculated independently without an array formula.
Work with spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and compatibility with Excel files, making it easy to move everyday spreadsheet work. It does not fix Excel Online's array formula limitations.

Frequently Asked Questions
Why won't my Excel table expand into the next row?
An array formula or spill range may occupy cells needed by the table. Check the cells below the table and move or revise any conflicting formula before adding the row.
Can a dynamic array formula spill inside an Excel table?
No. Enter the dynamic array formula outside the table and leave enough empty cells for its results. The formula can still refer to table data.
How do I edit a legacy multi-cell array formula?
Open the workbook in Excel desktop and select the entire array range before changing or deleting the formula. Changing just one cell in the array is not permitted.
Can I replace every array formula with a regular table formula?
No. A row-by-row formula is suitable only when it produces the intended result for each row. Formulas that need to return multiple cells or perform calculations across an array may require a different layout.
How can I request better array formula support in Excel Online?
In Excel Online, open the Help menu and look for Feedback to send Microsoft a description of the limitation and your workbook scenario.




