private static void RefreshPivotTable(Excel.Worksheet workSheet, string pivotTableName, string pivotFormula) { PivotTable pivot = (PivotTable)workSheet.PivotTables(pivotTableName); pivot.SourceData = pivotFormula; pivot.RefreshTable(); }