MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

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

  • Follow


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?
0
Reply Utf 1/15/2010 2:56:02 PM

microsoft.public.excel.misc 79177 articles. 66 followers.

0 Replies
399 Views

(page loaded in 0.04 seconds)

Similiar Articles:

Can I refresh worksheets in a specific order when I open a file ...
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...

open excel 2007 refresh query from batch file - microsoft.public ...
Can I refresh worksheets in a specific order when I open a file ... open excel 2007 refresh query from batch file - microsoft.public ... Can I refresh worksheets in a ...

Can I specify what order to refresh tabs? - microsoft.public.excel ...
Can I refresh worksheets in a specific order when I open a file ... Can I specify what order to refresh tabs? - microsoft.public.excel ..... excel.misc I know that if you ...

Refresh of Data - microsoft.public.excel.misc
Can I refresh worksheets in a specific order when I open a file ... I have multiple worksheets that contain data from MS query that I want to refresh on open.

Print Excel files from a BAT file. - microsoft.public.excel.misc ...
Can I refresh worksheets in a specific order when I open a file ... Print Excel files from a BAT file. - microsoft.public.excel.misc ... Can I refresh worksheets in a ...

Refresh folder list, Windws Mail - microsoft.public.windows.vista ...
Can I refresh worksheets in a specific order when I open a file ... Refresh folder list, Windws Mail - microsoft.public.windows.vista ... Can I refresh worksheets in a ...

Run time error 4003→what can I do ? - microsoft.public.vb ...
... open("C:\a.xls") >> Set xlsheet = xlbook.worksheets(1) >> xlsheet.Activate >> ~~ >> It can ... file in excel 2003,but it >> can't ... order to set things up so they can ...

Invalidate .vs. Refresh - microsoft.public.dotnet.languages.csharp ...
... only update that specific area. Refresh ... A formula in this worksheet contains one or more invalid ... Refresh ... Can You Save the DataGridView Sort Order / Update the ...

Word -- tabbed document sheets - microsoft.public.mac.office.word ...
... like tabbed browsers and tabbed worksheets (in excel), why can ... it becomes necessary to open a file which may be 10, 20, 100 times larger than necessary in order to see ...

macro open tabs - microsoft.public.excel.programming
Rename Worksheet Tab as File Name ... in the tab order of a ... all of the worksheets in an Excel workbook to separate pdf files for each tab. ... open excel 2007 refresh ...

7/30/2012 12:06:12 PM


Reply:
Privacy Policy | All Times Are GMT(UTC) | powered by