Microsoft announced the PivotTable #SPILL feature to Excel insiders today.
The #SPILL will replace the somewhat annoying "Can't refresh PivotTableX" pop up message that we currently receive when something is blocking a PivotTable from expanding. This brings PivotTables error messaging in live with Dynamic Array functions in Excel.
The #SPILL error will be displayed if you refresh a PivotTable and something is blocking the PivotTable from expanding. This often happens when a you add new field item in to a PivotTable row and the PivotTable then hits some text, values or another PivotTable in the cells below when it expands:
Video from Microsoft tech community here
In short you need to make it possible for the PivotTable to expand. This can be achieved in a couple of ways:
Video from Microsoft tech community here
To avoid having the #SPILL error in you PivotTable in the first place give some thought to the design of the layout of your model.
Give your Pivot Tables room to expand.
This series of articles focuses on new features soon to be released on Excel. This is based on announcements by the Microsoft Office Insider team.
See other articles in our Future of Excel series here.