Here’s a question from a reader:
Just heard of a new Business Intelligence add-in from Microsoft that ships with Excel and lets you crunch data from different data sources at the same time. That sounds interesting. I am wondering where can i find Power Pivot? How can i add it to Excel?
Thanks for the question.
Fully agree that Power Pivot is a bery powerful tool, and looks like it is picking up quite nicely as the “brains” of the Microsoft Business Intelligence suite.
Note: A far as i can tell, the Microsoft Data Analysis add-ins are now shipping as part of all Microsoft Office 365 subscriptions as well as Office 2019 Home, & Business and Home & student and Professional versions.
If for some reason, you would like to deactivate Power Pivot in order to troubleshoot any issue, execute the steps above according to your software version, but make sure to uncheck the add-in.
Hope it helps