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

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.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Brickcounter" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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
>

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

"Earl Kiosterud" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.
>
> --
> Earl Kiosterud
> www.smokeylake.com
> -----------------------------------------------------------------------
> "Brickcounter" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>>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
>>
>
>
>