Pivot Table Issues

Fix Excel PivotTable Column Expand and Collapse Buttons Not Working

Ayan Masood Oct 21, 2026 868 views

Question details

The expand and collapse (+/-) buttons for column fields in Excel PivotTables have stopped working and are unresponsive to clicks.

Fix Excel PivotTable Column Expand and Collapse Buttons Not Working

Product: Microsoft Excel
Device & OS: not provided
Scenario: Users are analyzing Power BI datasets using the 'Analyze in Excel' feature and interacting with column fields in the resulting PivotTable.
Observed behavior: Expand and collapse controls fail to work for column fields in Excel build 2301. Row controls and standard local PivotTables remain fully functional.

Before you start

Verify your current Microsoft Excel build version by navigating to File > Account before attempting to install updates or roll back your software.

Solution 1Recommended

Update Excel to a Newer Build

Since this is a known bug in build 2301, installing a newer patch released by Microsoft will restore the column expand and collapse functionality.

Microsoft frequently releases updates to fix bugs affecting Microsoft 365 services and Power BI connections. Check if a newer version is available for your update channel.

Open Account Settings

Launch Microsoft Excel, click on 'File' in the top-left corner, and select 'Account' from the bottom of the left-hand sidebar.

Check Update Options

Under the 'Product Information' section, locate and click the 'Update Options' drop-down button.

Install Updates

Select 'Update Now' from the menu. Excel will search for, download, and install any available updates that contain the bug fix.

Update Completion: Once the update finishes, restart Excel completely and reopen your Power BI connected spreadsheet to test the column buttons.

Solution 2

Roll Back to a Supported Earlier Build

If an update is not yet available or causes other issues, reverting your Office installation to a stable previous version (such as 15928.20216) is the most reliable workaround.

Free Microsoft Office alternative

Analyze Data Without Interruptions Using WPS Spreadsheet

If Excel bugs or complex update requirements are slowing down your workflow, WPS Office offers a stable, lightweight, and completely free alternative. With robust PivotTable features and high compatibility with Excel formats, you can keep analyzing your data seamlessly without worrying about broken controls.

1. Download and Install: Download WPS Office for free from the official website and run the quick installation.
2. Open Your Data: Launch WPS Spreadsheet and easily open your existing Excel data files.
3. Insert a PivotTable: Navigate to the Insert tab, click PivotTable, and drag your fields to analyze data effortlessly.

Full compatibility with Microsoft Excel formats (.xlsx, .xls, .csv).Powerful built-in PivotTable and data visualization tools.Lightweight application that runs smoothly without heavy mandatory updates.Free to use with a familiar interface, requiring no learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why do the row expand/collapse buttons work while column buttons fail?

This is a specific behavioral bug introduced in Excel build 2301. The bug specifically affects how column fields are processed when connected to Power BI datasets via the 'Analyze in Excel' feature, leaving row controls and standard local PivotTables unaffected.

How do I check my current Excel build number?

Open Excel, click on 'File' in the top-left ribbon, and select 'Account' at the bottom of the left menu. Look at the 'About Excel' section on the right side to find your Version and Build number.

What if I cannot update or roll back Excel due to IT restrictions?

If your software is managed by your organization's IT department, you will not be able to change the build manually. You need to report the build 2301 PivotTable issue to your IT administrator so they can deploy a rollback or push a new patch across your network.

Excel & Data Problems