Hi again Rollo;

Just to give you some feedback, I've tried 'everything' Bill has recommended
and I STILL can't get the bloody add-ins to update my EXISTING .xls (Excel
2003.xls) files to retrieve stock price quotes from moneycentral.msn.com!

But I did figure out a WORK AROUND. I finally added or inserted another
worksheet tab and named it "External Data" then I imported the watchlist,
portfolio, what-ever you want to call them from Yahoo!.com. I have several
lists of stocks so I just IMPORTED the list to the External Data sheet.

I then went to the Front sheet (tab) and placed the formula ='External
Data'!H3 into the the B3 cell adjacent to the Ticker Symbol, and grabbed this
cell (B3) with the 'handle' (the little square thingy in the lower right
corner) and dragged or filled it down my list of other Tickers, filling the B
Column with the appropriate matching Last Price displayed in the External
Data sheet.

Now I just use the Refresh Data icon (Data tab - connections) and the
external data will refresh all stock prices!

What a freakin' JOKE this new Excel 2007 program is !! I'd replace it with
the OLD Office XP suite of programs in a New York minute - MS SUCKS - big
time!


"Bill Sharpe" wrote:

RolloBurgess wrote:
Thanks Bill,
How do you install the add-in ?

Click Office Button, click Excel Options at bottom, select Add-ins.
MSNStockQuotes Function and User Interface add-in should be listed
there, since you were using them in Excel 2003. If not you may have to
download the addin from Microsoft. Look for "add-in programs" in Excel help.

Bill