'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix PivotTable Drill-Down Resetting Column Widths After Office Update
Question details
Users report that double-clicking a PivotTable to drill into details unexpectedly resets column widths, enlarges adjacent columns, or unhides hidden columns.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Drilling down into PivotTable details by double-clicking a value cell.
- Observed behavior
- Column widths are altered or reset, and hidden columns become visible, even when the 'Autofit column widths on update' setting is disabled.
Before proceeding, ensure you have saved a backup copy of your intricately formatted spreadsheet, as column width resets can damage your customized layout.
Verify Autofit Settings and Manually Restore Widths
Ensure the built-in PivotTable setting isn't causing the issue before assuming it's an update bug.
By default, Excel attempts to adjust column widths to fit new data when a PivotTable updates. Verifying this setting is turned off is the first step in troubleshooting layout issues during a drill-down.
Right-click anywhere inside your PivotTable and select 'PivotTable Options' from the context menu.
Navigate to the 'Layout & Format' tab. Look for the 'Autofit column widths on update' checkbox and ensure it is completely unchecked, then click 'OK'.
Double-click the data cell to perform your drill-down. If the columns still resize due to the update bug, manually drag the column headers back to your required widths.
Roll Back the Microsoft Office Update
Since this is a known regression in recent Office builds, reverting to a previous version is the most effective workaround until Microsoft releases a patch.
Submit Bug Feedback to Microsoft
Reporting the issue directly to Microsoft helps prioritize a permanent fix for this regression.
Try WPS Office for Stable PivotTable Performance
Tired of unexpected layout changes and update regressions in Microsoft Excel? WPS Office provides a highly stable, lightweight, and free alternative with excellent PivotTable capabilities that perfectly preserve your formatting.
Frequently Asked Questions
Why does double-clicking a PivotTable change my column widths?
Double-clicking activates the 'Show Details' drill-down feature. If 'Autofit column widths on update' is checked, or if there's a known bug in your Office version, the spreadsheet will automatically resize columns based on the newly extracted data.
How do I stop PivotTables from resizing columns on update?
Right-click your PivotTable, select 'PivotTable Options', navigate to the Layout & Format tab, and uncheck the 'Autofit column widths on update' box. Click OK to save your preferences.
Can I disable the drill-down feature entirely to prevent this bug?
Yes. Right-click the PivotTable, go to 'PivotTable Options', select the 'Data' tab, and uncheck 'Enable show details'. This prevents users from double-clicking to generate a new drill-down sheet, completely avoiding the column width bug.
