smart tags

[Guest]

I am using Excel 2003 and trying to put together a worksheet with stock
prices, using smart tags. The stock prices all update (I'm using MSN Money
Stock Quotes), but not every stock symbol displays a smart tag. The smart
tags are helpful as they carry a link back to news and other info on the
stock.

How can I get ALL the stocks to show smart tags? Incidentally, the stocks
I'm talking about are well known stocks like GM, Proctor & Gamble & Ford.

Thanks in advance.

 

[Excel_Geek]

You can download the Excel 2003/2002 Add-in: MSN Money Stock Quotes:

http://tinyurl.com/dw948

This won't automatically create a smart tag for GM, for example. But
you can use the "Insert Stock Quotes" function on the newly installed
toolbar to create a quote for GM, which will drop that quote onto the
sheet where you specify. Then you can copy and paste the cell with
"GM" in it (now with a smart tag) to where ever else you might need it,
and the smart tag will go with it.

 

[Guest]

Hey good stuff! Thanks for that solution, it's not slick, but it works!