Forum Discussion

riteshmuhatte's avatar
riteshmuhatte
New Contributor
5 years ago

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)

excel
sample_pipeline

2 Replies

  • nravon's avatar
    nravon
    New Contributor
    5 years ago
    Copy LinkReport

    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's avatar
    winosky
    New Contributor III
    5 years ago
    Copy LinkReport

    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.