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.

Fix the "Retrieving Data. Wait a Few Seconds" error in Microsoft Excel with these effective solutions, including deactivating browser extensions, clearing cookies ...

Excel SPILL errors occur when a formula returns multiple results. Learn how to fix #SPILL formula errors in Microsoft Excel.