Stay in the flow with PivotTable #SPILL! in Excel

Hi, Microsoft 365 Insiders! I’m Valerie Kistrina, a Product Manager on the Excel team. I’m excited to introduce PivotTable #SPILL!, a new feature in Microsoft Excel for Windows and for Mac. Instead of breaking your flow with confusing alerts, PivotTables can now collapse into a single cell with a #SPILL! error – so you can stay focused and resolve errors on your own terms, without unnecessary disruption.

Stay in the flow with PivotTable #SPILL! in Excel

PivotTable #SPILL! brings the familiar #SPILL! experience from dynamic arrays to PivotTables. If something is blocking your PivotTable from expanding – such as text, merged cells, tables, or the edge of your spreadsheet – you’ll see a #SPILL! error. This lets you address the issue at your own pace, so you can keep working without disruption and stay focused on your analysis.

How it works

1. Insert, refresh, or work with a PivotTable in Excel for Windows or for Mac, and if something’s in the way of the PivotTable expanding, the top-left cell will include a #SPILL! error.
2. To get your PivotTable out of the #SPILL! error:

• • Clear any cells that are blocking the PivotTable from expanding.
  • Move the PivotTable to a location with enough space.
  • Use the PivotTable Fields list pane to adjust your PivotTable until the error is resolved.
  • Use slicers and timelines to manipulate your PivotTable out of the error state.

Tips and tricks

• PivotTable #SPILL! impacts dependent analysis objects, such as formulas (e.g., GetPivotData), PivotCharts, and macros, while interaction objects like slicers and timelines remain unaffected.

Availability

This feature is available to Beta Channel users running:

• Windows: Version 2508 (Build 19309.20000) or later.
• Mac: Version 16.102 (Build 25090953) or later.

Feedback

We’d love to hear your thoughts on how this feature is working! Please select Help > Feedback in Excel to provide your thoughts and suggestions.

Learn about the Microsoft 365 Insider program and sign up for the Microsoft 365 Insider newsletter to get the latest information about Insider features in your inbox once a month!