If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

PivotChart Version (xlPivotTableVersion14 vs xlPivotTableVersion12)

Thread starter Cosmic
Start date Oct 27, 2017
Tags

chart office opened pivot version

Cosmic

New Member

Oct 27, 2017

I have a routine that creates a pivot chart and functions perfectly on my installation of Office 2010, however when opened and used by someone with Office 2007 the routine bombs while creating the pivot chart. The code in question is shown below:

Code:

        ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
            "WC_Summary!" & PTRng.Address, Version:=xlPivotTableVersion14).CreatePivotTable _
            TableDestination:="PTChartData!R1C1", TableName:="PTWC", DefaultVersion _
            :=xlPivotTableVersion14

If I change the portion Version:=xlPivotTableVersion14 to Version:=xlPivotTableVersion12 it works just fine.

I'd like to know if there is an easy way to have it create v14 or v12 as needed depending on the version of Office in which it is opened?