Excel Pivot Table
How to Fix Pivot Table Not Refreshing Issues in Excel
Learn how to fix Excel Pivot Table not refreshing issues with easy solutions for new data, filters, field errors, and overlaps.
Read article
Excel Pivot Table
95 articles
Excel Pivot Table
How to Create a Dropdown from a Slicer in Excel (with Easy Steps)
Learn how to create a dropdown from a slicer in Excel with simple steps—add a slicer, customize your pivot table, and finalize the dropdown.
Read article
Excel Pivot Table
How to Hide Filter Arrows in Excel Pivot Table
Learn how to hide filter arrows in Excel Pivot Tables by disabling field headers, captions, and using VBA for complete control.
Read article
Excel Pivot Table
How to Ungroup Dates in Excel Pivot Table (3 Simple Ways)
Learn how to ungroup dates in Excel Pivot Tables using the Ungroup feature, keyboard shortcuts, or by disabling auto grouping.
Read article
Excel Pivot Table
How to Group Dates by Month and Year in Excel Pivot Table
Learn how to group dates by month and year in an Excel Pivot Table using drag-and-drop and the Group Selection feature.
Read article
Excel Pivot Table
How to Sort Pivot Table by Sum of Values in Excel
Learn how to sort a Pivot Table by the sum of values using the Sort feature for horizontal sorting & a Calculated Field for vertical sorting.
Read article
Excel Pivot Table
How to Group Excel Pivot Table by Different Intervals
Learn how to group Excel Pivot Table data by equal or uneven intervals using built-in options or a helper column for better analysis.
Read article
![[Fixed] Cannot Group that Selection Error in Excel Pivot Table](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-excel-pivot-table-cannot-group-that-selection-67ca9338.webp)
Excel Pivot Table
[Fixed] Cannot Group that Selection Error in Excel Pivot Table
Fix the “Cannot group that selection” error in Excel Pivot Tables caused by wrong date formats, text strings, or Data Model issues.
Read article
Excel Pivot Table
How to Group Columns in Excel Pivot Table (3 Methods)
Learn how to group columns in Excel Pivot Tables using Calculated Fields, PivotChart Wizard, and Power Query for better data analysis.
Read article
![[Solved] Unable to Get the PivotFields Property of PivotTable Class](https://pub-b39c974f4c124a36a2fb517be38076ec.r2.dev/images/2026/08/featured-image-unable-to-get-the-pivotfields-property-of-the-pivottable-class-dde28374.webp)
Excel Pivot Table
[Solved] Unable to Get the PivotFields Property of PivotTable Class
Fix "Unable to get the PivotFields property of the PivotTable class" VBA error with solutions for field names, table references & selections.
Read article
Excel Pivot Table
How to Apply Conditional Formatting in Excel Pivot Table
Learn how to apply conditional formatting in Excel Pivot Tables using the formatting icon or by creating a new conditional rule.
Read article
Excel Pivot Table
How to Fix Pivot Table Not Recognizing Dates Issues in Excel
Learn how to fix Excel pivot table date issues by converting to proper date format, removing errors, and cleaning extra spaces.
Read article