Configuring: PowerPivot for Excel 2013


For configuring PowerPivot in Excel 2013 you need to follow below mentioned steps:

In Excel 2013 By default PowerPivot add-in is disabled and you need to enable it manually –

1) File –> Options –> Add-in –>Manage Select (Com Add-Ins)



2) After Selecting Com Add-in click GO, by default Add-ins are disabled




3) After checking required Add-ins, in my case I have selected PowerPivot and Power View; you will be able to get PowerPivot Tab in Ribbonimage


Few things to keep in mind before enabling Add-In

You will need…

  • .NET Framework 3.5 SP1
  • 64 BIT – this will enable PowerPivot to load extremely large data and take leverage of available memory on your box
  • Silverlight 5 for Power View

Comments (0)