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 [...]
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)
Ok. Now is is time for you guys to speak up! Here is a little informal poll. What is your favorite PowerPivot feature? I’ll tell you mine and then I’ll let everyone chime in via the post comments. Join in the fun!
My favorite PowerPivot feature isn’t a feature of PowerPivot at all. I love the [...]
Ok folks. Here comes a cool one.
As I am sure that everyone is aware by now, one of the most powerful new features of PowerPivot is that we do on-demand loading of embedded data. Well, if you are going to load it, then you had better at least think about unload it at some time. [...]
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
So you think that you have done everything right, but still SQL setup (in PowerPivot SharePoint integration mode) still reports “You don’t have a ‘Complete’ SharePoint installation.” How can this happen?
You might not have followed the installation guide. It tells you to first select “Farm” and then “Complete” on your first two screens after you [...]
One of the special considerations that arise when demonstrating PowerPivot is that you would like to ensure the workbooks that you are showing are kept in memory all of the time. PowerPivot does not have a built-in ‘pin’ feature to do this, but there is nice trick that you can use. Here is what I [...]