topic not a great solution, but one in Product Forum https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47419#M3169 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"". Tue, 03 Oct 2017 16:50:00 GMT Anonymous 2017-10-03T16:50:00Z Pivot refresh https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47418#M3168 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? Tue, 03 Oct 2017 11:47:00 GMT https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47418#M3168 DamianSurlicki1 2017-10-03T11:47:00Z not a great solution, but one https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47419#M3169 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"". Tue, 03 Oct 2017 16:50:00 GMT https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47419#M3169 Anonymous 2017-10-03T16:50:00Z I think the error that you https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47420#M3170 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. Tue, 03 Oct 2017 18:37:00 GMT https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47420#M3170 Anonymous 2017-10-03T18:37:00Z I am using this code: https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47421#M3171 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. Wed, 04 Oct 2017 11:09:00 GMT https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47421#M3171 AndrzejKaczor 2017-10-04T11:09:00Z @Andrzej.Kaczor thank you!!! https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47422#M3172 @Andrzej.Kaczor thank you!!! Wed, 29 Nov 2017 13:15:00 GMT https://community.blueprism.com/t5/Product-Forum/Pivot-refresh/m-p/47422#M3172 RohitSonawane2 2017-11-29T13:15:00Z