We have a problem, that client has Office 2007 with Latvian language pack. In that problem the same FOX PRO code that creates Excel report fails on creating PivotalTable. See failing code line below:
oPivotTable = oPivotCache.CreatePivotTable("Sheet!R1C5", "PivotTableName", 1)
Without installed language pack all works fine!