"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 |
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 |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com