| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refresh linked query
i have a pivot table in an excel sheet that is linked to an access database.
i would like to program a macro to refresh the pivot table. i thought the following would work, but it does not: FinalRowFRONT = Cells(Cells.Rows.Count, "A").End(xlUp).Row Range("a" & FinalRowFRONT).Select Selection.QueryTable.Refresh BackgroundQuery:=False how do i get the pivot table to refresh? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Refresh Query Table causing debug error with Background Refresh pr | Excel Programming | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) | Excel Programming | |||
Threaded Mode
