How to activate Excel add-ins

There are a number of COM Add-ins available for Excel including those for BI; Power Pivot, Power View, Power Query and Power Map. To activate these:

  1. Go to the Excel File Menu
  2. Select Options from the left menu
  3. An Excel Options window should now appear
  4. Select Add-ins from the Excel Options left menu
  5. Select COM Add-ins from the drop down menu at the bottom of the Excel Options window and click the GO button
  6. Ensure that the required Add-ins are ticked – as per the image at the top of the page
  7. Click the OK button
  8. You Excel ribbon should now reflect the selection you made. Power Pivot and Power Query have their own ribbons, whilst Power View and Power Map can be found as icons on the Insert Ribbon
We hope you found this useful and/or interesting. If so please like, share or comment.

One thought on “How to activate Excel add-ins

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s