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 Ribbon
Few things to keep in mind before enabling Add-In
You will need...