Hi,

I've just moved from Excel 2000 to 2002, this has caused some 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 each sheet which forms part of the url for each query. So the address for each query is:

http://www.advfn.com/p.php?pid=ukfin...&symbol=LSE%3A["QUOTE0"]

and the three letter code completes the address.

This works just fine in 95% of cases, and the data is returned just as I want it. However, in some cases the query retrieves information from a different table. This is because of an inconsistency in the table numbering in the source data. When I was running Excel 2000 I could fix this by going into the query paramaters and resetting the table value.

If I navigate with the browser and select the desired table this causes the address used in the query to become fixed. It is vital that the query remains dynamic (i.e. the "QUOTE0" bit) in the address for the effective functionality of the sheet.

Furthermore, I was experimenting with this, and set up a query through the browser interface directed at a table which one of my dynamic queries was already successfully returning. This returned the wrong table of data! This is a recognised problem - Microsoft states data cannot be queried from dynamically scripted tables, cf http://support.microsoft.com/kb/277899/en-us. But, that is not the 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 the browser interface? That would seem to be the most logical solution to my problem.

I never had these problems with Excel 2000, and I have had other problems migrating my spreadsheets to 2002. Has anyone else experienced similar difficulties?

Thanks for any help, it really is appreciated.

Bertie