Refresh Excel Pivot Table

The attached sample excel has three sheets:
Sheet “data” - This sheet has the raw dump of data
Sheet “pivot” - This sheet has a pivot build out of the “data” sheet
Sheet “stats” - This sheet builds a summary data using the “pivot” sheet

The goal is to refresh the pivot table in the “pivot” sheet once new data is added in the “data” sheet.
Any help would be greatly appreciated.

sample_pivot.xlsx (15.4 KB)

Well you can definitely automatically refresh a Pivot Table (via a Macro/VB) - not sure how that will work with Snap reading the file. Try adding the necessary Macro/VB and see what it gives you.

If you have a database lying around, I’d send data there through Snaplogic and have the data sheet connect to that local database so refreshing is easier.