macro updating imported data and pivot tables

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cam - 15 Apr 2008 16:47 GMT

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

Reply to this Message

solarmfg - 15 Apr 2008 17:32 GMT

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.

> Hello,
>
[quoted text clipped - 8 lines]
>
> Thanks

Reply to this Message

Cam - 15 Apr 2008 19:11 GMT

This doesn't work for me. Any other sugguestion?

> 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
[quoted text clipped - 12 lines]
> >
> > Thanks

Reply to this Message