Pivot Table update automatically?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have created pivot table i have problem when ever i enter data "Data Sheet"
then after i have to always manually update Pivot report sheet.
Is there any way i can automatically update Pivot report sheet when ever i
entry data in "data sheet"

Shital shah
 
You could use an event procedure to refresh the pivot table when its
sheet is activated. For example:

Private Sub Worksheet_Activate()
ActiveSheet.PivotTables(1).PivotCache.Refresh
End Sub


To use this code, right-click on the sheet tab, and choose View Code.
Copy and paste the code onto the sheet's module, where the cursor is
blinking.
 
Back
Top