@Heldyyyyy question is if the pivot tables will get updated if you open the Excel file which you can do at the end of an Excel writer node.
I was able to at least detect pivot tables with Phyton in knime. Maybe it is possible to also update or refresh them. This most likely will require a temporary opening of the files in Excel in the background: