web query will not fill down formulas

[DianneZ]

Hello!
In Excel 2003 I have had a web query working for several years pulling down
currency rates from msn. Previously, it also filled down formulas next to the
data that came in from the web.

Now, however it seems the table dimensions have enlarged because it deletes
my formulas that used to fill down perfectly.

I have tried to guage the edge of the query range by watching the Web query
toolbar, when it dims, I assumed I was out of the range and could safely set
up formulas to fill down. I set the Query properties to fill down - and
refresh and nothing fills, I can do this manually of course but can anyone
tell me what I could do to have my formulas fill down again?
Thanks!
DianneZ

 

[Don Guillett]

I don't use MSN but am very familiar with finance web queries. How are you
doing this? If desired, send me a workbook to the address below.

 

[Don Guillett]

I went to
http://moneycentral.msn.com/investor/market/exchangerates.aspx?selRegion=0&selCurrency=1
and got this three column hit. Is this what you are using? If so, what is
the problem?

Currency In US Dollar Per US Dollar
Argentine Peso 0.31776 3.147
Australian Dollar 0.9086 1.1006
Brazilian Real 0.57176 1.749
British Pound 1.95925 0.5104
Canadian Dollar 0.99128 1.0088
Chinese Yuan 0.13935 7.176
Euro 1.46843 0.681
Hong Kong Dollar 0.12822 7.7993
Indian Rupee 0.02521 39.66
Japanese Yen 0.00928 107.78
Korean Won 0.00106 945.64999
Mexican Peso 0.09293 10.7608
Russian Rouble 0.04066 24.5917
Swedish Krona 0.15791 6.3329
Swiss Franc 0.91441 1.0936