PowerPivot Excel 2010 Save File Version

[onebluekey]

Hi,

I am very interested in the features of PowerPivot. Is it ok just to install a stand alone Excel 2010 with Office 2007? Would I be able to save PowerPivot files as .xlsx?

Any input is greatly appreciated!

Lynn

 

[Derek Brown]

You can have multiple versions of Office on the same computer - have a look at:
http://support.microsoft.com/kb/928091/

I have Office 2003, 2007 and 2010 on mine (I decided to remove Office 97 and Office XP but they probably would still be OK). The secret is to make sure that they are installed into different folders/directories.

You can select/deselect some of the Office programs when you do a 'Custom' install.

PowerPivot files cannot be opened in Excel 2007 or earlier.

 

[onebluekey]

Derek,

Thank you for your reply. I also found additional information from below...

http://www.infoworld.com/t/business.../powerpivot-excel-2010-power-excel-people-759

That workbook can be opened in Excel 2007, but only as a static snapshot; you can't edit or otherwise interact with the underlying data, since only Excel 2010 has the under-the-hood wizardry needed to talk to PowerPivot.