Can I specify what order to refresh tabs?

B

begrry

I am using Excel 2003, and I have a report on Sheet1 tha is using
vlookup formulas to Several other sheets in my workbook. I have some
sheets that are pulling in Queries from a database and i have some
sheets that are pivot tables. I have all sheets set up to refresh on
file open, but i want to make sure that the sheets with the queries
update first, then the pivot tables.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I refresh worksheets in a specific order when I open a file? 0
Need Help with a VBA subroutine 0
Refresh order when refreshing all in a workbook 1
Consolidation Table from Different Excel Tabs with Different Format 1
Dealing with a Pivot Table (when I don't want to) 0
Pivot table report invalid 0
pivot won't update. 0
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3

Top