Excel Magic Trick 1256

DESCRIPTION

Grouped Dates in PivotTable With Becomes UnGrouped When I Refresh!!!
Learn how to build a PivotTable with Grouped Month and Year Dates and add a Slicer for a Marine Species Data Set, and then learn how to fix the PivotTable with Slicer when Grouped Dates Become Ungrouped:
(00:12) Problem Introduction
(00:47) Build a PivotTable with Grouped Month and Year Dates and add a Slicer for a Marine Species Data Set.
(03:25) Add New Records to Excel Table and then Refresh PivotTable Report
(03:44) Then learn how to fix a PivotTable with Grouped Dates that become Ungrouped by fixing the data mismatch in the Date Column. (Can’t have an empty Record in the Data Set).

WORKBOOKS