Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (select Table Design > Tools > Convert to range).

The spilled array formula you're attempting to enter will extend beyond the worksheet's range. Try again with a smaller range or array. In the following example, moving the formula to cell F1 will …

If you select another cell in the spill area, the formula will be visible in the formula bar, but the text is "ghosted", and can't be changed. If you need to update the formula, you should select the …

Apr 7, 2025 · Learn how to use the spilled range operator to return a spilled array range in its entirety.

If you select another cell in the spill area, the formula will be visible in the formula bar, but the text is "ghosted", and can't be changed. If you need to update the formula, you should select the …

When Excel shows ##### because the cell has a negative date or time value, make sure that you: Verify dates and times are positive values when you’re using the 1900 date system.

Custom functions that refer to more than 10,000 cells cannot be calculated in Excel for the web, and will produce this #CALC! error instead. To fix, open the file in a desktop version of Excel.

Spilled array formulas aren't supported in Excel tables. Try moving your formula out of the table, or converting the table to a range (click Table Design > Tools > Convert to range).

The #SPILL! error likely indicates that a cell in the Python output range already contains data. This could be the result of returning a Python object as Excel values.

#PYTHON errors are returned by Python in Excel formulas when a formula can't run properly. See below for specific cases.