The macro recorder is you friend :)



--
Regards
Dave Hawley
www.ozgrid.com
"joemeshuggah" wrote in message
...
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?