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