We can then create PivotTables based on this model to analyze multiple tables of data. No more VLOOKUPs to pull data together into one big list. Relationships can then be created between the different tables of data. It does this by loading the data into the internal data model of Excel and not onto a worksheet. Power Pivot enables us to work with big data beyond the 1,048,576 limitation and still produce smaller, leaner and faster workbooks than a standard PivotTable. In reality, it can struggle as you get to 100,000 or even before that depending on what you have in your workbook.
Although an Excel worksheet can handle 1,048,576 rows of data.
