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.


****al shah wrote:
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"

****al shah



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html