To avoid SPILL error using ArcGIS Function in Excel table - convert the Excel table to a range and keep your function dynamic, which involves placing the formula on a separate sheet, you can then create cell references within the original table that point to the function located on the other sheet, as demonstrated in the video.