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.