Pivot Table Issues

Fix Excel PivotTable Slicers Moving or Resizing After Drill Down

Guest Writer Sep 30, 2026 869 views

Question details

Users need to resolve an issue where Excel slicers and shapes move, shrink, or lose macro functionality when drilling into a PivotTable.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Drilling down into PivotTable data to view underlying details.
Observed behavior: Slicers and shapes unexpectedly change size, move from their original positions, or stop responding to assigned macros, often following a recent Office update.

Before you start

Verify if a recent Office update was installed right before the issue began. It is highly recommended to test the workbook on a different device to determine if the problem is device-specific or a broader application bug.

Solution 1Recommended

Lock Slicer Properties to Prevent Moving and Resizing

Adjusting the slicer's format properties ensures it remains fixed in place regardless of row and column changes caused by the PivotTable drill-down.

By default, Excel objects might be set to move and size with the cells beneath them. Changing this setting forces the slicer to ignore the expansion or contraction of PivotTable rows.

Access Size and Properties

Right-click on the affected slicer or shape and select 'Size and Properties' from the context menu.

Modify the Positioning Settings

In the formatting pane that appears on the right side of the screen, expand the 'Properties' section.

Apply 'Don't Move or Size'

Select the radio button labeled 'Don't move or size with cells'. Close the pane and repeat this process for any other affected slicers or shapes.

Lock Slicer Properties to Prevent Moving and Resizing

Pro Tip: If you have multiple slicers, you can hold down the 'Ctrl' key to select all of them at once, and then apply the property change simultaneously.

Solution 2

Create a Sample Workbook to Report the Bug

If the issue persists despite locking object properties, it is likely a bug introduced in a recent Excel update requiring Microsoft developer investigation.

Free Microsoft Office alternative

Avoid Excel Update Bugs with WPS Office

If recent Microsoft Excel updates are causing glitches with your PivotTable slicers and macros, consider switching to WPS Office. It provides a highly stable, lightweight spreadsheet environment that handles complex data, PivotTables, and slicers without unexpected layout disruptions.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite.
2. Open Your Workbook: Launch WPS Spreadsheet and open your existing .xlsx file containing the PivotTable and slicers.
3. Analyze Data Stably: Drill down into your PivotTable data seamlessly without worrying about slicers resizing or macros breaking.

Fully compatible with Microsoft Excel formats (.xlsx, .xls) and complex PivotTable structures.Stable performance that does not suffer from frequent, disruptive layout bugs upon drill-down.Free, lightweight, and easy to use with a familiar spreadsheet interface.Seamless migration of your existing data analysis workflows and slicer dashboards.

microsoft office alternative - wps office

Frequently Asked Questions

Why do my Excel slicers shrink when I drill down into a PivotTable?

This usually happens because the slicer's formatting properties are set to 'Move and size with cells'. When a drill-down action reveals details by expanding or hiding rows and columns, the attached slicer changes shape as well. Changing the property to 'Don't move or size with cells' typically resolves this.

How do I fix macros that stop responding after a PivotTable drill-down?

If shapes with assigned macros become unresponsive, the drill-down action may be glitching the object's layer order or event triggers, which is a known bug in certain Excel updates. You can try locking the shape's properties, or open the file in an alternative application like WPS Office to bypass the bug.

Is there a way to roll back a recent Excel update that broke my slicers?

Yes, if you are using Microsoft 365, you can roll back to an earlier version using the Office Deployment Tool or Command Prompt, though this requires administrative privileges and technical knowledge. A faster workaround is often opening the file in a compatible alternative suite until an official patch is released.

Excel & Data Problems