Need Help With PivotTable

[Joefried]

Hi There

thank you for looking at my question

i created a Pivot table out of an invoice but would like if i replace the DATA from the invoice tab the pivot table should update it self?

Please help me on how this could be done i'm using 2007

thanks for trying

 

[VoG]

Right click in the PT, select Refresh.

 

[Joefried]

how can it be done automatically?

 

[Cyclops755]

Try pasting this into the code for the worksheet containing the pivot table

Private Sub Pivot_Refresh()
Activeworksheet.RefreshAll

End Sub

 

[Joefried]

where in the worksheet?

 

[Cyclops755]

Welcome to the boards, btw . Right-click the sheet tab that contains the PVT, and select "View Code". Then paste the code into the window that opens.

 

[Joefried]

well its in the pivot table pages but is not working

 

[Cyclops755]

I have the same same situation in the workbook I'm currently working on. The code I have verbatim running on the worksheet containing my pivot table is:

Private Sub Worksheet_Activate()
    ActiveWorkbook.RefreshAll
End Sub

See if this works for you

 

[Joefried]

is it working by you?

 

[Cyclops755]

Yep. Do you have any other code/macros in your workbook?