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.
Exception from HRESULT: 0x800A03EC
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 :
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
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.
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.
I signed up for the Hortonworks Certified Associate exam last Thursday. Figured if I sign up, I'd have to take the test. And if I tak...
Saw a post today on Twitter, " Microsoft releases CNTK, its open source deep learning toolkit, on GitHub " This is big news. Be...
It seems like open source applications are the mainstream today. So many new products delivered through Aache foundation. Some do this. S...