Can I refresh worksheets in a specific order when I open a file?

begrery

Guest

Posts: n/a

15th Jan 2010

I have multiple worksheets that contain data from MS query that I want to
refresh on open. I also have several worksheets that contain Pivot Tables
that I want to refresh on open. I want to be sure that the query worksheets
update first, then the pivot tables. Is there a way to specify what order
the sheets refresh in when the file is open?

« Disabling the "&[Time]" or "&[T]" in Excel headers and footers | Can i drop the year from dd/mm/yyyy for graph »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
REFRESH DATA in all Worksheets upon open of workbook	=?Utf-8?B?c2ZsZWNr?=	Microsoft Excel Misc	0	19th Oct 2007 12:08 AM
print specific worksheets in specific order.	jarvo	Microsoft Excel Programming	1	11th Apr 2006 11:05 AM
Defining an auto-open macro that prints specific worksheets	sam	Microsoft Excel Programming	1	21st Nov 2003 08:52 PM
Have to click refresh in order to open .pdf , .doc .*	Johnny Rock	Windows XP Internet Explorer	0	25th Sep 2003 11:44 PM
Have to click refresh in order to open .pdf , .doc .*	Johnny Rock	Windows XP Internet Explorer	0	25th Sep 2003 11:41 PM