Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro updating imported data and pivot tables
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro updating imported data and pivot tables
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. "Cam" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro updating imported data and pivot tables
This doesn't work for me. Any other sugguestion?
"solarmfg" wrote: 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. "Cam" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Imported Data (Excell 2003) | Excel Worksheet Functions | |||
Updating pivot items on 3 pivot tables contained on one sheet | Excel Programming | |||
updating pivot tables using dynamic data source | Excel Discussion (Misc queries) | |||
Auto updating pivot tables using external XML data | New Users to Excel | |||
UPDATING IMPORTED DATA | Excel Worksheet Functions |