I thought I had what was a simple request. Create an Excel template with one sheet containing the detailed data and the other with a pivot table. Initially, everything appears to be working correctly until one looks a little closer and discovers that the pivot table never gets refreshed. Based on what I've seen on similar posts I discovered that apparently one needs a macro to refresh the pivot table (even though I checked refresh on open for the pivot table options). I'm kinda "new" to pivot tables and creating macros and I can't seem to get anything to refresh the pivot table. Any suggestions would be greatly appreciated.

This message has been edited. Last edited by: Kerry,

Hi Kevin,

It seems like you have a case opened regarding this issue, can you please keep all posted once you hear an update/solution? Thank you in advance for sharing with all.

Cheers,

Kerry

Private Sub Worksheet_Activate()
Range("A1").Select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
End Sub