SPILL Erorr causing all kinds of errors

%3CLINGO-SUB%20id%3D%22lingo-sub-2133963%22%20slang%3D%22en-US%22%3ESPILL%20Erorr%20causing%20all%20kinds%20of%20errors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2133963%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20creating%20a%20basic%20Excel%20doc%20to%20track%20some%20gift%20card%20balances%2C%20and%20in%20the%20first%20sheet%20I%20have%20the%20total%20with%20a%20formula%20to%20subtract%20deductions%20on%20another%20sheet%20from%20the%20total.%20When%20I%20do%20this%20in%20the%20first%20row%2C%20it%20creates%20the%20SPILL%20formula%2C%20and%20I%20can't%20edit%2C%20nor%20do%20I%20want%20it%20there.%20How%20do%20I%20remove%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20can't%20remove%20this%2C%20how%20do%20I%20get%20the%20next%20row%20to%20be%20a%20different%20dataset%3F!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2133963%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I'm creating a basic Excel doc to track some gift card balances, and in the first sheet I have the total with a formula to subtract deductions on another sheet from the total. When I do this in the first row, it creates the SPILL formula, and I can't edit, nor do I want it there. How do I remove this? 

 

If I can't remove this, how do I get the next row to be a different dataset?!

1 Reply
I would suggest including the formula you are using (perhaps the workbook itself with any/all sensitive information removed or, if possible, an example of your workbook and formula using mock data).

I don't have dynamic arrays and don't expect to be able to help you find the issue, but you can assist the other respondents in providing a specific answer with more information that is specific to your situation.