Forum Discussion
Auto populating in table #SPILL! error
I am working on an expense spreadsheet. All expenses and their info are dumped into a sheet called "Itemized Expenses"; on another sheet called "Monthly Expenses", I want it to auto populate the G/L ...
How to correct a #SPILL! error
#SPILL errors are returned when a formula returns multiple results, and Excel cannot return the results to the grid. For more details on these error types, see the upper link.
Those solutions won't fix the problem since the data needs to be in a table; I'm using slicers to filter out the large amounts of data that are going to be inputted.