Excel Magic Trick 1158

Get Millions of Rows of Data into PivotTable without PowerPivot, Excel 2013


See how to Get Millions of Rows of Data into Excel 2013 for a PivotTable without PowerPivot:
(00:10) Problem Setup for Excel 2013 when you don’t need Group by Date
(01:06) Data Ribbon, Get External Data, then in Import Data dialog box: select “Only Create Connection” and check “Add this data to the Data Model”
(01:59) Create PivotTable and in the Create PivotTable dialog box select “Use an external data source” and then in the Tables tab select “Tables in Workbook Data Model”.
(02:43) No GROUPING BY DATE with data Model
(02:52) PivotTable with Slicers

Be the first to comment

Leave a Reply