A more engaging, “Fisher Price” style of interaction with a finished report was required. The PowerPivot team (of which I was a member at the time) decided that PowerPivot was not going to “shine” in customers eyes with the existing appearance of Excel. There are good reasons why 2007 is not supported, and I worked closely on two of them while I was at Microsoft. Is this some nefarious MS plot? Not this time. That is sometimes a useful concession to IT. Lastly, even your PowerPivot authors can still run 2007 for most tasks, and have 2010 installed side by side for PowerPivot tasks. A single “departmental server” running on a reasonably capable desktop computer can do the job quite nicely). (Also keep in mind that your entire org does NOT have to adopt SharePoint, either. Only the PowerPivot authors need to have 2010, and then they can publish their work to SharePoint 2010 (and servers are often upgraded long before desktops). The next thing to remember is that your entire organization does NOT need to upgrade to 2010. If you are just in an evaluation phase right now, that likely will help you quite a bit. Stuck on Excel 2007? Not all hope is lost…įirst off, you can get a trial version of Excel 2010 by clicking here.

I’m sad to say that PowerPivot is NOT supported, and simply will not function, with Excel 2007. So I can understand why it seems like 2007 should work. Excel 2010 sure looks a lot like Excel 2007 – they both use the Ribbon instead of traditional menus, and they both use the new XLSX file format.

How to use slicers in excel 2007