Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help with Refreshing Querytables.
Hello all,
I have 3 querytables that connects to an external database in my Excel file. All 3 query tables are looking up 3 values in worksheet "Data". The 3 values are in Cells D15, D16 and D17 of the Data worksheet. The way I have the querytables to work is as followed: 1. I populate a value in Cell D15, and data populates for Querytable 1. 2. For Cell D16, I have a Vlookup formula to grab the data from Querytable 1 by looking up the value in Cell D15. The Querytable 2 then populates based on the value in Cell D16. 3. For Cell D17, I have the same setup as Cell D16. The Querytable 3 is populated based on the value in Cell D17. The problem that I have is since Querytables 2 and 3 are looking up the values in Cells D16 and D17, the Querytables 2 and 3 start refreshing before the values in Cells D16 and D17 populate. Because of that, I receive error messages for not able to refresh the Querytables 2 and 3. Is there a way to control the refresh on Querytables 2 and 3 that refresh after the values are populated in Cells D16 and D17 by Vlookup, respectively? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
QueryTables | Excel Programming | |||
QueryTables.Add and XML | Excel Programming | |||
QueryTables command | Excel Programming | |||
QueryTables Add | Excel Programming |