Data refresh problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brickcounter - 08 Mar 2007 17:55 GMT

I downloaded an xl template worksheet which has links to MSN Money website
(for updating stock prices)
As I have xl97, and the worksheet was created in a later version, I saved it
as a xl97 worksheet.
When I 'refresh data' it downloads the latest prices.........sometimes.
More usually I get the message 'xl has encountered a problem, and needs to
close..'
Any ideas on what might be causing this?
If I knew how the link works, I could start with a new worksheet, but I
can't find any web queries relating to this worksheet.
Brickcounter

Reply to this Message

Earl Kiosterud - 08 Mar 2007 18:16 GMT

Brickcounter,

If you know where at the MSN Mondy web site it's getting the data, it's fairly
straightforward to set up your own web query. This may not be exactly as it was in XL97.
Data - Get external data - New web query. It will prompt you for the stuff it needs.

Signature

Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------

>I downloaded an xl template worksheet which has links to MSN Money website (for updating
>stock prices)
[quoted text clipped - 6 lines]
> queries relating to this worksheet.
> Brickcounter

Reply to this Message

Brickcounter - 09 Mar 2007 10:47 GMT

Thanks, but to do it that way I think would need to set up a web query for
each stock (there are 30+). With the current arrangement, when it works, I
just enter all the stock codes in one cell. So I would like to sort the
problem that causes xl to close.
bc

> Brickcounter,
>
[quoted text clipped - 14 lines]
>> can't find any web queries relating to this worksheet.
>> Brickcounter

Reply to this Message