Forum Discussion
excel in 365
I have a spill error, "we can't spill within a table". I am working with a new sheet and a form I have created. When I enter my data the first line comes out correctly. When I add a new set of data t...
BruceFin I suspect you are entering a formula with a dynamic array function inside a structured table.
What formula are you entering? Can you upload a screenshot showing the problem?
Yes I was in an array function but my table was not structured properly. I believe that was why I was getting the message, "we can't spill within a table". I started over and used ctrl T to create the table. Doing this now allows me to add data with a form and enter formulas for calculations. Now when I enter the data the formulas auto calc and I am no longer getting the #spill error.
I am new to this aspect of using Excel. I have always just tabbed through my columns to enter the data but using a form makes it much easier I have discovered. Thanks for your interest and help.
I am new to this aspect of using Excel. I have always just tabbed through my columns to enter the data but using a form makes it much easier I have discovered. Thanks for your interest and help.