This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Refresh Excel Pivot Table

riteshmuhatte
New Contributor

‎07-18-2021 06:42 AM

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)

Preview file
16 KB
0 Kudos
2 REPLIES 2

nravon
New Contributor

‎07-19-2021 09:43 AM

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.

0 Kudos

winosky
New Contributor III

‎07-20-2021 01:50 PM

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.

0 Kudos