I've written many times about the many benefits of formatting your data as a structured table in Microsoft Excel. However, despite this, there's one major issue that continues to throw a spanner ...

If you are getting some other warning message with the #SPILL error, you can move ahead and apply a suitable fix. Read: Excel can’t insert new cells because it would push non-empty cells. 2 ...

When you enter a dynamic array formula in one cell, Excel automatically populates the adjacent cells needed to display all the results. You’ll know it’s working when you see a blue border around this ...

It’s doubtful that Excel will automatically sense and update a pivot table if you add new cells outside of the current table’s range. That’s a weakness that Sheets has, too.

4] Table formula Spilled array formulas are not supported in an Excel table. Move the formula out of the table or convert the table to a range: Click Table Design > Tools > Convert to range.