Refresh Excel Pivot Table

Question

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)

nravon · Answer

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.

winosky · Answer

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.

Forum Discussion

Refresh Excel Pivot Table

Recent Discussions

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?