Refresh of Excel sheet pivot table

[Pachan]

Hi Team,

Please let me whether there is any Excel Function which will do refresh of pivot table.Since "Save" is not refreshing the pivot table, I am closing and opening the XL file to achieve refresh. Is there any better way of achieving that, if we don't have a XL function.

Thanks,

Thomas

[Juvigy]

$oExcel.ActiveSheet.PivotTables ("PivotTable5" ).PivotCache.Refresh