PowerPivotGeek?

Who is this mystery man?
Click on the icon to find out. Who is powerpivotgeek?

PowerPivot for Excel 2010 is now available as a download

For those who would looking for specific downloads of the PowerPivot for Excel 2010 RTM bits , here they are:

Important : If you install the 32-bit version of Excel 2010, you must use the 32-bit version of PowerPivot. If you install the 64-bit version of Excel 2010, you must use the 64-bit version of PowerPivot.

PowerPivot [...]

Querying data within the PowerPivot Excel client add-in

Recently we have been seeing some users complain about how the PowerPivot Excel client add-in deals with queries. There are three limitations that you need deal with when working with SQL (TSQL, PL/SQL, or whatever) and stored procedures:

The result set must have a name associated with each column. If you are not returning the column [...]

Fix for PowerPivot for Excel 2010 November CTP released

And update (April 7, 2010 14:19 PST) – fix has been released!

See: http://blogs.msdn.com/powerpivot/archive/2010/04/07/fix-for-powerpivot-expiration-released.aspx

PowerPivot for Excel 2010 November CTP Expired

If you are running CTP3 PowerPivot for Excel client bits you have likely ran into our time bomb issue.

From: http://blogs.msdn.com/powerpivot/archive/2010/04/02/powerpivot-for-excel-2010-november-ctp-expired.aspx

If you are running the November 2009 CTP version of the PowerPivot for Excel 2010 add-in, your add-in expired on April 1st. We apologize for any inconvenience this may have caused you.

The SQL Server team will [...]

64-bit verses 32-bit . . . What’s right for you?

Recently we been hit with a rash of inquiries around whether folks should install the 32-bit version of the PowerPivot client, or go with the larger capacity 64-bit version. Office 2010 is the first version of Office to offer a native 64-bit option. In previous releases, you had to install the 32-bit version to run [...]

Collation, Localization and Globalization, oh my!

From time to time we get questions about these three topics. Let’s take them one at a time and see how PowerPivot works under the covers. PowerPivot works on all types of collations, languages and regional settings.

(if you like this kind of ‘internationalization stuff’, read on)

PowerPivot and Windows 7

Recently I had a conversation with one of our excellent beta testers and I want to make sure that everyone was clear about running PowerPivot on Windows 7.

Windows 7 is only supported for PowerPivot for Excel; Windows 7 is not a supported OS for PowerPivot for SharePoint

Uninstalling PowerPivot for Excel

A trick for the client-side folks doing build-to-build reinstallations (or if you wish to clear all of the PowerPivot code from your client): besides uninstalling “Microsoft PowerPivot for Excel” (via control panel Add/Remove/Uninstall Programs, the exact wording varies depending on the OS you are running), you may also have to delete files in:

C:\Program Files\Microsoft Analysis [...]

Memory Considerations in PowerPivot

In scanning through some recent discussions on the PowerPivot forums, I noticed this very nice posting by Marco Russo (http://sqlblog.com/blogs/marco_russo/archive/2010/01/26/memory-considerations-about-powerpivot-for-excel.aspx) . I strongly recommend it.

The only additional point I would like to make is that the RTM version of PowerPivot has an additional check on the in-memory database when saving to disk. The CTP3 (and [...]

And oh, you need this one more thing

LATE BREAKING NEWS: This appears to be an Office 2010 beta issue. Rumor has it (I will confirm later) that VSTO will be installed along with an Excel 2010-only install when Office ships next year. But it does impact us today.  Sorry. The latest, late breaking news is that VSTO will continue to be installed [...]