View Single Post
  #2   Report Post  
Dale Fye
 
Posts: n/a
Default Refresh queries, graphs, and charts

I have an Excel workbook that contains several worksheets that are linked to
Access queries, of an ORACLE database. This workbook also contains numerous
tabs which contain pivot tables (based on the worksheets that are linked to
the Access db) and charts based on the pivot tables.

I am looking for a way to quickly refresh the links to the Access queries,
as refresh all of the data in the pivot tables and charts, without having to
move to each of these worksheets and refresh them.

Hope this makes sense.

Dale