#SPILL! error

%3CLINGO-SUB%20id%3D%22lingo-sub-2321681%22%20slang%3D%22en-US%22%3E%23SPILL!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321681%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20named%20range%20column%20Value1.%3C%2FP%3E%3CP%3EIn%20another%20cell%20at%20the%20right%20of%20the%20named%20column%20(Value1%20from%20F7%20to%20F13)%2C%20but%20in%20the%20area%20of%20the%20rows%20of%20the%20named%20range%20column%2C%20I%20simply%20put%20the%20formula%20%3DValue1%20in%20J9%20and%20I%20receive%20the%20%23SPILL!%20error!%3F!%3C%2FP%3E%3CP%3EAlso%2C%20it%20is%20marking%20with%20the%20dotted%20line%20a%20range%20of%20the%20same%20height%20as%20the%20named%20range%20but%20shifted%20to%20start%20from%20the%20cell%20with%20the%20formula%20(J9%20to%20J15)%20and%20is%20showing%20in%20all%20these%20cells%20the%20same%20formula%20in%20grey.%3C%2FP%3E%3CP%3EWhen%20I%20double-click%20in%20J9%2C%20the%20area%20for%20cell%20address%20is%20showing%20WORKDAY.INTL!!!%3C%2FP%3E%3CP%3ESomething%20should%20be%20corrupted.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2321681%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2321950%22%20slang%3D%22en-US%22%3ERe%3A%20%23SPILL!%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2321950%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1044653%22%20target%3D%22_blank%22%3E%40Mihai_Zamfirescu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20enter%20%3DValue1%20you%20place%20the%20values%20from%20range%20F7%3AF13%20into%20the%20range%20starting%20from%20J9%20as%20one%20object%20(aka%20spill).%20If%20there%20is%20not%20enough%20space%20for%20this%20object%2C%20i.e.%20you%20already%20have%20some%20value%20in%20one%20of%20these%20cells%2C%20you%20have%20%23SPILL!%20error.%20And%20since%20such%20spill%20is%20one%20object%20you%20can't%20edit%20elements%20within%20it%2C%20only%20entire%20object.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20in%20your%20file%20I%20see%20no%20error%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20374px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F277870i144A2F9DB53327BE%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have a named range column Value1.

In another cell at the right of the named column (Value1 from F7 to F13), but in the area of the rows of the named range column, I simply put the formula =Value1 in J9 and I receive the #SPILL! error!?!

Also, it is marking with the dotted line a range of the same height as the named range but shifted to start from the cell with the formula (J9 to J15) and is showing in all these cells the same formula in grey.

When I double-click in J9, the area for cell address is showing WORKDAY.INTL!!!

Something should be corrupted.

 

 

 

1 Reply

@Mihai_Zamfirescu 

If you enter =Value1 you place the values from range F7:F13 into the range starting from J9 as one object (aka spill). If there is not enough space for this object, i.e. you already have some value in one of these cells, you have #SPILL! error. And since such spill is one object you can't edit elements within it, only entire object.

 

However, in your file I see no error

image.png