Home
> Uncategorized > Configuring: PowerPivot for Excel 2013
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 Ribbon
Few things to keep in mind before enabling Add-In
You will need…
- .NET Framework 3.5 SP1 for PowerPivot
- 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
Categories: Uncategorized
“Configuring: PowerPivot for Excel 2013 | Karan Gulati
(SSAS Maestro)” Fabric Roman Shades genuinely got me simply hooked on your web page!
Iwill wind up being back again a whole lot more normally.
Thanks a lot -Katrin
Yes, its Excel 2013 PowerPivot if you refer step 9 you will notice that I have used PowerPivot, ir-respective of build. if you have ODBC provider in place you can use Excel 2010 PowerPivot or excel 2013 PowerPivot.
Contact me if you need further clarifications.