Need help with refreshing data
 

Hello,

I have a sheet named "Data" with data imported from Access, then a pivot
table and pivot chart sheets from the source "Data" sheet. What do I put in
the code to first refresh the "Data" sheet first, then update all the pivot
table sheets and charts?
I tried this code, but it only refresh the "Data" sheet, but not the pivot
table.

Thisworkbook.refreshAll

Thanks