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 ...