https://community.blueprism.com/t5/Product-Forum/Update-Pivot-data-source-using-VBA-code/m-p/78762#M30751 I have a requirement to update data source of the pivot in a workbook. Challenge is, I cannot create a macro to update the Workbook is downloaded from one of the data source. I have tried below code and getting 'Exception from HRESULT: 0x80070057 (E_INVALIDARG)' error. Const xlDatabase as Integer = 1 Const xlR1C1 as Integer = -4150 Dim wb as Object = GetWorkbook(handle, workbook) Dim ws as Object = wb.Worksheets(worksheet) Dim newDataSource Try newDataSource = wb.PivotCaches.Add (SourceType:=xlDatabase, _ SourceData:= "[Sheet1]" &amp; ws.Range(newLink).Address(ReferenceStyle:=xlR1C1)) Dim pt = ws.PivotTables("PivotTable1") pt.ChangePivotCache (newDataSource) success = True Catch e As Exception &nbsp;&nbsp; &nbsp;success = False &nbsp;&nbsp; &nbsp;Message = e.Message End Try Anyone tried this scenario? Replies are appreciated. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Mon, 25 Dec 2017 17:00:00 GMT Anonymous 2017-12-25T17:00:00Z https://community.blueprism.com/t5/Product-Forum/Update-Pivot-data-source-using-VBA-code/m-p/78762#M30751 I have a requirement to update data source of the pivot in a workbook. Challenge is, I cannot create a macro to update the Workbook is downloaded from one of the data source. I have tried below code and getting 'Exception from HRESULT: 0x80070057 (E_INVALIDARG)' error. Const xlDatabase as Integer = 1 Const xlR1C1 as Integer = -4150 Dim wb as Object = GetWorkbook(handle, workbook) Dim ws as Object = wb.Worksheets(worksheet) Dim newDataSource Try newDataSource = wb.PivotCaches.Add (SourceType:=xlDatabase, _ SourceData:= "[Sheet1]" &amp; ws.Range(newLink).Address(ReferenceStyle:=xlR1C1)) Dim pt = ws.PivotTables("PivotTable1") pt.ChangePivotCache (newDataSource) success = True Catch e As Exception &nbsp;&nbsp; &nbsp;success = False &nbsp;&nbsp; &nbsp;Message = e.Message End Try Anyone tried this scenario? Replies are appreciated. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> Mon, 25 Dec 2017 17:00:00 GMT https://community.blueprism.com/t5/Product-Forum/Update-Pivot-data-source-using-VBA-code/m-p/78762#M30751 Anonymous 2017-12-25T17:00:00Z https://community.blueprism.com/t5/Product-Forum/Update-Pivot-data-source-using-VBA-code/m-p/78763#M30752 I also faced the similar issue, Anyone have a solution Fri, 04 May 2018 00:12:00 GMT https://community.blueprism.com/t5/Product-Forum/Update-Pivot-data-source-using-VBA-code/m-p/78763#M30752 EswarPalivela 2018-05-04T00:12:00Z