locked
compatibility between Powerpivot for Office 2010 and Powerpivot for Office 2013 RRS feed

  • Question

  • I thought Powerpivot came in two flavors: 2010 and 2012 and that we could install the add-in for either of them in Excel 2010 or Excel 2013 (Professional Plus).

    I also believed that a PowerPivot created with Excel 2010 and the 2012 PowerPivot Add-in could be opened and used with Excel 2013 (Professional Plus).

    Unfortunately, this does not seem to be the case and I receive an error like "This workbook has a Powerpivot data model created using a previous version of the PowerPivot add-in..."

    Question: is it possible for someone having Excel 2010 and the Powerpivot 2012 Add-in to produce Powerpivot files that can be opened either in Excel 2010 or Excel 2013 without having to convert the file?


    Eric Mamet _ MCDBA, SQL Server 2005 MCTS, MCAD .Net

    Monday, October 27, 2014 9:22 PM

Answers

  • Conversion is strictly necessary and irreversible between the latest version of Power Pivot for Excel 2010, and Power Pivot in Excel 2013 (365 or disc - Pro Plus). Once converted to 2013, there is no way to open the same file again in 2010.

    If you do not have the latest version of Power Pivot for Excel 2010, I believe you will need to upgrade that, then use that to open an older Excel 2010 workbook, then open in 2013 to upconvert.

    If you have users on multiple versions of Excel, SharePoint is your best bet for sharing a Power Pivot workbook.

    If you have users on multiple versions of Excel who must collaborate on building a workbook, you've got some installations, VMs, or spare laptops coming your way.

    • Marked as answer by EricLeBouffon Monday, October 27, 2014 10:20 PM
    Monday, October 27, 2014 9:46 PM

All replies

  • Conversion is strictly necessary and irreversible between the latest version of Power Pivot for Excel 2010, and Power Pivot in Excel 2013 (365 or disc - Pro Plus). Once converted to 2013, there is no way to open the same file again in 2010.

    If you do not have the latest version of Power Pivot for Excel 2010, I believe you will need to upgrade that, then use that to open an older Excel 2010 workbook, then open in 2013 to upconvert.

    If you have users on multiple versions of Excel, SharePoint is your best bet for sharing a Power Pivot workbook.

    If you have users on multiple versions of Excel who must collaborate on building a workbook, you've got some installations, VMs, or spare laptops coming your way.

    • Marked as answer by EricLeBouffon Monday, October 27, 2014 10:20 PM
    Monday, October 27, 2014 9:46 PM
  • Thanks

    Eric Mamet _ MCDBA, SQL Server 2005 MCTS, MCAD .Net

    Monday, October 27, 2014 10:20 PM