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...
One of two lines of development may be appropriate.
The first is to leave the calculation within the last column of the Table but make sure that the structured references are to single cells by using the "@" notation.
The alternative is to move outside the table and create a dynamic array formula that references entire table columns.
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. My problem was far more basic and due to a lack of knowledge and understanding.
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. My problem was far more basic and due to a lack of knowledge and understanding.