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)

image

 

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

 

image

 

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