Data refresh problem

[Brickcounter]

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

 

[Earl Kiosterud]

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.

 

[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