Power Pivot for Excel 2010 and 2013 share workbook

Question

Hello,

We have:

1. Power Pivot for Excel 2010 and
2. Power Pivot for Excel 2013

We don’t want to upgrade all machines for Excel 2013, but we want to share workbooks, e.g. open/change/ close  same workbook in Excel 2010 and Excel 2013.

Is it possible?

What are the options to do this?

Thanks

---

TK

Answer 1

Hi tLkRpt01,

From what I've experienced, when you open the workbooks created in Power Pivot for Excel 2010 in Excel 2013, you are prompted to upgrade the Power Pivot model contained. Once it's been upgraded, Excel 2010 isn't able to read the model anymore.

You can either maintain two versions of the Power Pivot workbook (Excel 2010 and 2013) to guarantee that both versions of Excel can open it, or use Power Pivot for SharePoint 2013 to remove the dependency on the installed version of Excel (which I appreciate will be the least feasible option if you don't already have the infrastructure).

Please see the following Official Microsoft Office help articles for further details:

Version compatibility between Power Pivot Data Models in Excel 2010 and Excel 2013

http://office.microsoft.com/en-gb/excel-help/version-compatibility-between-power-pivot-data-models-in-excel-2010-and-excel-2013-HA103929426.aspx

Power Pivot error: “This workbook has a Power Pivot data model created using a previous version of the Power Pivot add-in. You’ll need to upgrade this data model with Power Pivot in Microsoft Excel 2013”

http://office.microsoft.com/en-gb/excel-help/power-pivot-error-this-workbook-has-a-power-pivot-data-model-created-using-a-previous-version-of-the-power-pivot-add-in-youll-need-to-upgrade-this-data-model-with-power-pivot-in-microsoft-excel-2013-HA103948214.aspx?CTT=5&origin=HA103929426

Upgrade Power Pivot Data Models to Excel 2013

http://office.microsoft.com/en-gb/excel-help/upgrade-power-pivot-data-models-to-excel-2013-HA103356104.aspx

Hope this helps,

Michael

Answer 2

Thank you Michael!

Tanya

---

TK