C
claytorm
Hi,
I've just moved from Excel 2000 to 2002, this has caused som
problems.
I have a workbook containing about 350 sheets, all with the same query
The only variable parameter is a three letter code in cell a1 of eac
sheet which forms part of the url for each query. So the address fo
each query is:
http://www.advfn.com/p.php?pid=ukfinancials&btn=s_ok&sm1=0&sm2=0&sm3=0&sm4=0&sm5=0&symbol=LSE:["QUOTE0"]
and the three letter code completes the address.
This works just fine in 95% of cases, and the data is returned just a
I want it. However, in some cases the query retrieves information fro
a different table. This is because of an inconsistency in the tabl
numbering in the source data. When I was running Excel 2000 I could fi
this by going into the query paramaters and resetting the table value.
If I navigate with the browser and select the desired table this cause
the address used in the query to become fixed. It is vital that th
query remains dynamic (i.e. the "QUOTE0" bit) in the address for th
effective functionality of the sheet.
Furthermore, I was experimenting with this, and set up a query throug
the browser interface directed at a table which one of my dynami
queries was already successfully returning. This returned the wron
table of data! This is a recognised problem - Microsoft states dat
cannot be queried from dynamically scripted tables, c
http://support.microsoft.com/kb/277899/en-us. But, that is not th
case, as my successful dynamic query on the same data shows.
*So, how can I set the table value without having to do so through th
browser interface?* That would seem to be the most logical solution t
my problem.
I never had these problems with Excel 2000, and I have had othe
problems migrating my spreadsheets to 2002. Has anyone else experience
similar difficulties?
Thanks for any help, it really is appreciated.
Berti
I've just moved from Excel 2000 to 2002, this has caused som
problems.
I have a workbook containing about 350 sheets, all with the same query
The only variable parameter is a three letter code in cell a1 of eac
sheet which forms part of the url for each query. So the address fo
each query is:
http://www.advfn.com/p.php?pid=ukfinancials&btn=s_ok&sm1=0&sm2=0&sm3=0&sm4=0&sm5=0&symbol=LSE:["QUOTE0"]
and the three letter code completes the address.
This works just fine in 95% of cases, and the data is returned just a
I want it. However, in some cases the query retrieves information fro
a different table. This is because of an inconsistency in the tabl
numbering in the source data. When I was running Excel 2000 I could fi
this by going into the query paramaters and resetting the table value.
If I navigate with the browser and select the desired table this cause
the address used in the query to become fixed. It is vital that th
query remains dynamic (i.e. the "QUOTE0" bit) in the address for th
effective functionality of the sheet.
Furthermore, I was experimenting with this, and set up a query throug
the browser interface directed at a table which one of my dynami
queries was already successfully returning. This returned the wron
table of data! This is a recognised problem - Microsoft states dat
cannot be queried from dynamically scripted tables, c
http://support.microsoft.com/kb/277899/en-us. But, that is not th
case, as my successful dynamic query on the same data shows.
*So, how can I set the table value without having to do so through th
browser interface?* That would seem to be the most logical solution t
my problem.
I never had these problems with Excel 2000, and I have had othe
problems migrating my spreadsheets to 2002. Has anyone else experience
similar difficulties?
Thanks for any help, it really is appreciated.
Berti