macro updating imported data and pivot tables

C

Cam

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
 
S

solarmfg

I typically use the command ActiveWorkbook.RefreshAll, but you need to make
sure that you do NOT allow enable background refresh, or the pivot table will
"update" before the "Data" sheet has fully refreshed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refreshing external data on individual sheets in a specific sequen 1
Pivot Table Question 2
Macro to run on all files in a folder but exclude sheets with PivotTable, Pivot Charts and Charts 16
Playing back a Pivot Table macros 2
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Using VBA to create charts 1
refresh multiple pivot tables in workbook 2
Pivot tables wont work in protected sheet? 3

Top