Macro will not fire

[jrobin5881]

I constructed a pivot table of the data on sheet 3 in the workbook and then renamed the pivot table worksheet "Rollup". What I'm trying to do is have the pivot table located on "Rollup" refresh automatically if/when I edit sheet 3 where the original information is stored.

But the code I'm using below (which I have attached to sheet 3) will not fire when I change any data?

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 
 'If data on this worksheet changes, refresh the pivot table
    Sheets("Rollup").PivotTables("PivotTable1").RefreshTable

End Sub

 

[SkipVought]

SelectionChange is not Change.

You want Worksheet_Change.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

I'd suggest, instead to use the WorksheetActivate event.

Why refresh every swingin' time your change something in the source data? Why not when you activate the sheet containing the PT, assuming that it is never active when any of the source data is changed.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[jrobin5881]

maybe I'm going about it wrong.
I send the workbook out as an email tracking sheet. My intent is to copy and paste the responses into sheet 3 as they're returned to me. So when I do that I want the pivot table on the "Rollup" sheet to refresh to include the new data without me having to pull up the toolbar and click the refresh button.

 

[SkipVought]

Exactly my thought as well.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}