excel spill error with row multiplication

%3CLINGO-SUB%20id%3D%22lingo-sub-1937592%22%20slang%3D%22en-US%22%3Eexcel%20spill%20error%20with%20row%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937592%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20issues%20with%20excel%20when%20naming%20a%20row%20(row_name)%20to%20use%20in%20formula.%20Using%20the%20named%20row%20in%20a%20formula%20for%20cells%20below%20creates%20a%20spill%20error.%20When%20using%20the%20row_name%20to%20multiply%20I%20get%20a%20spill%20error%20that%20says%20that%20the%20spill%20range%20is%20too%20big.%20When%20I%20send%20it%20to%20a%20colleague%20it%20solves%20itself%20and%20the%20error%20goes%20away%2C%20what%20is%20going%20wrong%3F%20In%20the%20case%20below%20I%20have%20used%20the%20name%20%22Inflation_factor_Mid_year_nominal%22%20shown%20in%20the%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22runner200_0-1605728655791.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F234487i08D4D926B8F65ED4%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22runner200_0-1605728655791.png%22%20alt%3D%22runner200_0-1605728655791.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1937592%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1939555%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20spill%20error%20with%20row%20multiplication%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1939555%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F873878%22%20target%3D%22_blank%22%3E%40runner200%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20some%20data%20that%20is%20be%20obstruction%20show%20the%20result%2C%20or%20the%20cell%20is%20merged.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%23SPILL!%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3Berror%20introduce%20in%20Excel%20with%20Dynamic%20Arrays%20(Microsoft365%20%5Bformally%20Office365%5D%20%E2%80%93%20mac%2Fwindows%20and%20Excel%20Online)%20with%20new%20calculation%20engine%20to%20handle%20the%20array%20functionality.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20blog%20post%20might%20be%20help%20for%20you%20to%20more%20in%20detail%20about%20spill%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fhow-to-correct-a-spill-error-ffe0f555-b479-4a17-a6e2-ef9cc9ad4023%23%3A~%3Atext%3DThis%2520error%2520occurs%2520when%2520the%2Cthe%2520obstructing%2520cell(s).%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EHow%20to%20correct%20a%20%23SPILL!%20error%20-%20Office%20Support%20(microsoft.com)%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexcelexciting.com%2Fwhat-is-the-spill-error-and-how-to-fix-it%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelexciting.com%2Fwhat-is-the-spill-error-and-how-to-fix-it%2F%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20you%20are%20sending%20the%20file%20to%20your%26nbsp%3B%3CSPAN%3Ecolleague%26nbsp%3B%3C%2FSPAN%3Ethe%20information%20is%20not%20getting%20spill%20because%20he%2Fshe%20don't%20have%26nbsp%3B%3CSPAN%3Enew%20calculation%20engine%20to%20handle%20the%20array%20functionality.%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eif%20you%20are%20still%20facing%20the%20issue%20kindly%20request%20you%20to%20please%20attach%20the%20sample%20file.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%20%26amp%3B%20like%20it%20to%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am having issues with excel when naming a row (row_name) to use in formula. Using the named row in a formula for cells below creates a spill error. When using the row_name to multiply I get a spill error that says that the spill range is too big. When I send it to a colleague it solves itself and the error goes away, what is going wrong? In the case below I have used the name "Inflation_factor_Mid_year_nominal" shown in the

 

runner200_0-1605728655791.png

 

1 Reply

Hi @runner200 

 

There is some data that is be obstruction show the result, or the cell is merged. 

 

#SPILL! error introduce in Excel with Dynamic Arrays (Microsoft365 [formally Office365] – mac/windows and Excel Online) with new calculation engine to handle the array functionality.

 

this blog post might be help for you to more in detail about spill

How to correct a #SPILL! error - Office Support (microsoft.com)

https://excelexciting.com/what-is-the-spill-error-and-how-to-fix-it/

 

when you are sending the file to your colleague the information is not getting spill because he/she don't have new calculation engine to handle the array functionality. 

 

if you are still facing the issue kindly request you to please attach the sample file.

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more