S
Steve C.
In Excel 97-2003, I had created in a macro to create a pivot table from a
range of data. However, when I converted the file to Excel in Office 2007, I
get VBA errors.
The converted workbook is now an xlsm file with macros enabled.
Not sure what else to do. The VBA error is:
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Loans!R8C2:R416C55",
Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="Sheet1!R3C1", TableName:="PivotTable1",
DefaultVersion _
:=xlPivotTableVersion12
range of data. However, when I converted the file to Excel in Office 2007, I
get VBA errors.
The converted workbook is now an xlsm file with macros enabled.
Not sure what else to do. The VBA error is:
Sheets.Add
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
"Loans!R8C2:R416C55",
Version:=xlPivotTableVersion12).CreatePivotTable _
TableDestination:="Sheet1!R3C1", TableName:="PivotTable1",
DefaultVersion _
:=xlPivotTableVersion12