In Excel 2010, what is the difference between working with Excel 2007 (i.e. Version 12) PivotTable objects and Excel 2010 (i.e. Version 14) PivotTable objects? There don't appear to be any from what I can see.

I have a workbook with two PivotTables, one created in Excel 2007 (i.e. the PivotTable object is version 12) and the other created in Excel 2010 (i.e. the PivotTable object is version 14).

So far, both PivotTables appear to have exactly the same functionality when viewed in Excel 2010. For example, I can add slicers, and named sets to both PivotTables without any issues.

Also, is it possible to upgrade an Excel 2007 (i.e. Version 12) PivotTable object to an Excel 2010 (i.e. Version 14) PivotTable object? If so, how?

Can an Excel 2010 (i.e. Version 14) Pivot Table object be downgraded to an Excel 2007 (i.e. Version 12) PivotTable object?

Hi,

I think we can open the Excel 2007 file directly with Excel 2010. In Excel 2010, when you open a workbook that was created in Excel 97-2003, it is automatically opened in Compatibility Mode, and you see Compatibility Mode in square brackets next to the file name in the Excel. Because Excel 2007 uses the same XML-based file format (.xlsx or .xlsm) as Excel 2010, an Excel 2007 workbook does not open in Compatibility Mode.

See Excel 2007 and Excel 97-2003 features that are not supported in Excel 2010 in the following link.

For Excel 2007 to open an Excel 2010 file, see the Unsupported PivotTable features part in the link:

http://office.microsoft.com/en-us/excel-help/use-office-excel-2010-with-earlier-versions-of-excel-HA010342994.aspx#BM3c

Hi Team,

I have Windows application which creates a PivotTable with below code:

Microsoft.Office.Interop.Excel.Range rngData;
Microsoft.Office.Interop.Excel.PivotCaches pivoteCaches;
Microsoft.Office.Interop.Excel.PivotCache pivoteCache;
rngData = objExWorkSheet.get_Range("A1:" + colAlphaChr1 + colAlphaChr2 + (FpSpread1.Sheets[0].RowCount + 1).ToString(), System.Type.Missing);
pivoteCaches = objExWorkBook.PivotCaches();
pivoteCache = pivoteCaches.Add(Microsoft.Office.Interop.Excel.XlPivotTableSourceType.xlDatabase, rngData);
pivoteCache.CreatePivotTable("Sheet2!R9C1", "PivotTable3", true,Microsoft.Office.Interop.Excel.XlPivotTableVersionList.xlPivotTableVersionCurrent);

At pivoteCache.CreatePivotTable it is giving below error with Office 2013:

The parameter is incorrect. (Exception from HRESULT: 0x80070057 (E_INVALIDARG)).

Where as with Office 2010 it is working fine without any error.

Please can anyone help me on this resolution.

I have tried using PivotCache.Create() method instead of PivotCahe.Add() as well.
Also tried with pivot versions XlPivotTableVersionList.XlPivotVersion14.

It agains show the same error as above.

Please can any one help on this.