"Dale Fye" wrote in message
...
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



Try CTRL+ALT+F9

/Fredrik

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