9/11/2011

First try at Power Pivot for Denali

Downloaded Power Pivot for Excel today from Microsoft.

Prerequisite is to have Office/Excel 2010 version - glad I bought this for new PC as the $### investment will soon pay off.

First thing to mention, be sure to download the correct version.

I assumed I had the 64 bit of Office 2010 installed, however, during the install it let me know to get the 32 bit instead.

The install is straight forward, click, I agree, click, click, install...

Once installed, when you open Excel, a wizard pop up asking you to install the customization - just do it!

In Excel 2010, there is a tab at the far right hand side of the top ribbon bar.

Click on the Power Pivot window launcher.  It takes a minute.

By the way, I do like the new version of Office Excel 2010 - clean looking - easy to use - and my two favorite programs of all time are Excel and Notepad...

Okay, it threw an error: Embedded Analysis Services Engine: Could not open embedded Power Pivot Data.

This crashed the application and forced a hard shutdown/restart of Excel.

Quick Google found this link:

A rocky start none the less.


============================
Error Message:
============================
Exception from HRESULT: 0x800A03EC
============================
Call Stack:
============================
Server stack trace:
   at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
   at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
   at Microsoft.AnalysisServices.Modeler.FieldList.GeminiProxy.MethodInvokeCallBack(String memberName, String dispID, BindingFlags flags, Object[] args, Boolean ignoreRetry)
   at Microsoft.AnalysisServices.Modeler.FieldList.GeminiProxy.HandleMethodInvoke(IMethodCallMessage callMessage)

Exception rethrown at [0]:
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.Office.Interop.Excel.OLEDBConnection.Reconnect()
   at Microsoft.AnalysisServices.Modeler.FieldList.InProcServer.LoadOLEDBConnection(Boolean raiseCompleteEvent)
============================

Meanwhile, the auto wizard thing-a-ma-bob sent the errors to Microsoft to check for a solution.

In the mean time I found this link all about PP.

Reran Excel-->Power Pivot-->threw the following error:




Found this link to troubleshoot:

Okay, going to re-think this by downloading the Power Pivot for SQL Denali link after removing the R2 version first...


Before that need to download the Visual Studio 2010 Tools for Office Runtime which requires .Net Framework 4.0.

How to: Install the Visual Studio Tools for Office Runtime Redistributable


Downloaded and ran the .Net 4.0 Framework repair option.  Took a few minutes.







After getting the correct prerequisite files loaded and installed, we now have access to Power Pivot for Excel 2010.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Thoughts to Ponder