When should you use Power Pivot in Excel? When you have an old version of Excel. When you want to build interactive visualizations. When you heavily rely on PivotTables. When you want monthly updates to your data analysis application.