Please take a look at this quick video showing how XlsIO can be used to update and create PivotTable in an Excel workbook.