Thoughts when Installing PowerPivot – Client

So, I’m in a session at MS BI Conference 2010 with Dave Wickert, and he’s doing a great job of working us through things to look out for when installing the PowerPivot client.

This is an Add-In that runs in the context of Microsoft Excel 2010. Any version of Excel that supports add-ins will support the PowerPivot add-in (which is almost any version!)

The download is available from http://www.powerpivot.com/download.aspx

Make sure you download and install the version that correlates to the version of Excel (not your Operating System). So, basically 32-bit Excel = 32-bit Add-in (regardless of 64 bit OS) And yes, you want to use the 64-bit version if at all possible. It allows you to create and manage larger datasets, any size that fits in RAM will work.

However, please note that only 4G files can be saved to disk, and only 2G files can be uploaded to Sharepoint. Yes, only J

Preconditions for the Add-in to work include:

  1. VSTO installed and running
    1. The Complete install of Office manages this by default
    2. If installing only Excel, be sure to select “Shared Components” as well to include VSTO
  2. The PowerPivot add-in is enabled. (once installed)
    1. Check under File – Options – Addins
    2. Ensure that the add-in is not in the Disabled State
  3. If the add-in is still gone, even if both are ok, it is possible to expose the VSTO exceptions on Excel start up
    1. Create an environment variable, VSTO_SuppressDisplayAlerts, and set to 0
    2. Check www.powerpivotgeek.com for full details

Debugging options for the client add-in can be set through PowerPivot à Settings. It’s possible to log events off to a log file, which can be opened and analysed in SQL Server Profiler. Also possible to create a snapshot of the current memory usage, by clicking “Snapshot”.

The settings window is also the equivalent of HelpàAbout in most apps. The RTM current version of the add-in is 10.50.1600.1

Advertisements

,

  1. Leave a comment

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 )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: