Pivot refresh

[DamianSurlicki1]

Hi, I'm a little bit stuck with pivot refresh in Excel. I did an object in Excel VBO named "Pivot Refresh" with code below: Dim wb, ws As Object Dim excel, sheet As Object wb = GetWorkbook(handle, workbookname) ws = GetWorksheet(handle, workbookname, worksheetname) wb.Activate() ws.Activate() excel = ws.Application sheet = excel.ActivateSheet sheet.PivotTables(pivotname).RefreshTable This is my last code, unfortunately not working...Check Code returns no mistakes. After execution the object I get message: "Could not execute code stage because exception thrown by code stage: The given key was not present in the dictionary. Can you help me with this problem?

[Anonymous]

not a great solution, but one way to do it is to create a RefreshAll macro within the workbook, then use Excel VBO ""Run Macro"".

[Anonymous]

I think the error that you have is related to the handle that you use, try to create a new Excel instance and pass its handle to your code.

[AndrzejKaczor]

I am using this code: dim worksheet as object worksheet= GetWorksheet(Handle, Workbook_name, Worksheet_name) worksheet.PivotTables(pivot_name).PivotCache.Refresh And it works for me.

[RohitSonawane2]

@Andrzej.Kaczor thank you!!!