Refresh queries, graphs, and charts

#1 April 1st, 2005, 08:28 PM

"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

#2 April 1st, 2005, 08:29 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pulling Excel charts and graphs into Powerpoint is a nightmare	littleearthquakes	Powerpoint	1	October 17th, 2004 04:13 AM
How do I get my pictures, logos, charts or graphs to show in Powe.	humber	Powerpoint	1	October 5th, 2004 07:10 PM
Problem sizing charts and graphs	J Newell	Powerpoint	6	August 27th, 2004 02:26 AM
Charts and Graphs will not hold their size	Mike Winstead	Setting up and Configuration	1	December 5th, 2003 09:01 PM