I need to change the Data Source Range from my excel data sheet dynamically and refresh myPivoTable1. xlwings or win32com any code will do. pls help. Thanks in advance

I tried to refresh pivot1 changing the source data range from A2:S50 to A2:S900 and refresh the PivotTable in Excel using xlwings and win32com. But I could not do that. If anyone can help that would be really great.Thanks in advance.