how to change Data Source Range and refresh PivotTable
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
xlwings how to change Data Source Range and refresh PivotTable
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