Refresh the pivot table automatically

C

celia

Private Sub Worksheet_Change(ByVal Target As Range)

'If data on this worksheet changes, refresh the pivot table
Sheets("Pivot").PivotTables("PivotTable1").RefreshTable

End Sub


I use this coding to refresh the pivot table once the data in the sheet
(Book1.xls)changed. However, the problems is the data I actually refer
from another workbook, Book2.xls

The data are entered by the users every week. Then I will copy the
workbook with the updated data to replace the original workbook. The
pivot table cannot refresh automatically and I will have to refresh the
pivot table manually.

Any idea about this?

Please advice!

Thanks!


+----------------------------------------------------------------+
| Attachment filename: example.zip |
|Download attachment: http://www.excelforum.com/attachment.php?postid=355001|
+----------------------------------------------------------------+
 
Top