PowerPivotGeek?

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

Archives

A Peek Inside: Why no cross-farm support?

From time to time, particular from knowledgeable SharePoint users coming up to speed with PowerPivot, I get the question: “PowerPivot have ‘cross-farm’ support”. As you can see from the title of this post, we don’t support it – and in this “A Peek Inside” I hope to explain why.

First, what is SharePoint ‘cross-farm’ support [...]

Watch out, your domain might be showing . . .

Several new SharePoint 2010 configuration issues will impacting some PowerPivot sites and I wanted to share them with you. These restrictions are with Excel Services and have to do with the way that Windows authentication is handled, i.e. you have set the Excel Services authentication set to “Windows”, not using Secure Store or “None”. This impacts PowerPivot [...]

Cheat sheets on how to install the server

Just posted: a new section of the blog (http://powerpivotgeek.com/server-installation/) dedicated to detailed, step-by-step instructions on how to install PowerPivot for SharePoint in common configurations, such as an “All-In-1” server, or an existing SharePoint farm, etc. Ultimately we expect most of this information to be in Microsoft white papers, but you get to see it first [...]

Tip: Use a fixed port# for Central Admin

I don’t know about you but I am always getting confused by all of the tidbits of information that I have to remember. Modern technology has its drawbacks. Now that I have used SharePoint for many months, one of the things that I found that I was always forgetting was port# used by Central Admin. [...]

Another tip – always save your workbooks at cell A1

As you start to develop large workbooks you will likely run into a by-design behavior that will drive you crazy – it did for me!

If your workbook grows beyond a single thumbnail snapshot when posting to a PowerPivot Gallery, you will notice that the workbook seems to render in the wrong place, most likely in [...]

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 [...]

A Peek Inside: Why are domain accounts needed?

Have you ever had to do something that you knew (you just KNEW) that lots of folks were going to scream – and scream loud – about? This is one of those cases – I can just feel it!

Ok, here goes. There have been several recent newsgroups postings concerning why we require domain accounts [...]

PowerPivot for SharePoint BOL is now available

Along with the CTP3/beta2 bits that were pushed today, we have also released the Books-On-Line CTP3 documentation for PowerPivot for SharePoint. I will do a few postings in a bit with the critical portions of BOL that I think that everyone should know about, but for the time being, it is great to just get [...]

A *WAY-COOL* facility –> A Virtual Lab for PowerPivot

Buried in the launching of CTP3/beta2 bits, is this tidbit: “Microsoft Virtual Lab: PowerPivot for Excel 2010”. Basically this facility is a remotely hosted VM with Excel 2010, PowerPivot for Excel and SQL Server 2008 R2 RDBMS. WOW!

You signup for the course and you have about 2 hrs of connect time with the lab. You [...]

All of the CTP3 bits are now live

Rather than list all of the links, I will just point to PowerPivot.com. It has a very nice consolidated ‘cheat sheet’: http://www.powerpivot.com/download.aspx – I have just one strong suggestion. Until mid-to-late December, I strongly suggest that if you are going to install PowerPivot for SharePoint that you use Windows 2008 SP2 as your base OS [...]