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)

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 Ribbon

 

image

 

 

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
Advertisement
Categories: Uncategorized
  1. March 13, 2013 at 5:44 pm

    “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

  2. April 7, 2013 at 4:45 pm

    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.

  1. January 4, 2013 at 6:17 pm
  2. January 4, 2013 at 6:30 pm
  3. March 28, 2013 at 5:59 am

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 )

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

%d bloggers like this: