.NET with BI development tips, tricks and experiences.

Once again all praise goes to PowerPivot-info.com. This time it is down to their comprehensive installation guide of PowerPivot with SharePoint 2010. I followed their guide meticulously and had no issues whatsoever on my virtual Windows Server 2008 R2 instance. The only problem I had was with the PowerPivot gallery previews being generated once I was installed and deploying PowerPivot workbooks. This was a known issue and covered in their installation guide. I tip my hat gentlemen. Great work guys, you have my gratitude and thanks.

Just completed installing PowerPivot for Microsoft Excel 2010. As I am not a huge Office user I chose to go the whole nine yards and completely uninstall 2007. If it did not work or had loads of bugs it was not going to slow my day down. I had also been told by our resident I.T. gurus that the x64 version cannot run alongside Office 2007.

This guide from PowerPivot-info.com has to be the one stop shop for a painless install. Looking further down the line it has some great examples for getting started as well as a detailed installation guide for Sharepoint 2010.

So far it is going great and have only come across one major issue. When having launched the PowerPivot window from inside Excel, I promptly dragged it over to my second monitor so I could work with both at the same time. When I clicked off the PowerPivot window it disappeared and could not get it back. Alt+Tab etc. had no effect. A restart of Excel resolved it.