Many thanks Celtic.

"Celtic_Avenger " wrote in
message ...
I the BVA code for the update button created........enter the following
code

ActiveWorkbook.RefreshAll

That will refresh all the pivot tables in that workbook, and then the
chart will update itself from the pivot tables.

Hope this helps

Celtic_Avenger


---
Message posted from http://www.ExcelForum.com/