Have been using the MSN Stock quote add-in quite successfully for long time to obtain stock information such as company name, exchange, shares outstanding, market capitalization, until now. Recently a number of my updates return #VALUE! in the field (sometimes 1 cell eg. exchange is updated but company name is not). Most of stocks are Canadian prefaced with CA: although do update for other countries as well such as US:, AU:. Many of the stocks are smaller companies with limited trading.I know the stock symbols are correct & quotes can be found on MSN Money Central website.

At times I recieve #VALUE! and if I play with the ticker (e.g. delete a letter and then change it back again) it sometimes works. Seems to be no rhyme nor reason

When inserting stock quotes I use Canada but have also used US.

Have uninstalled & reinstalled the add-in and it is checked. Under Autocorrect have smart tags operating.

Using :
OS Name Microsoft Windows XP Professional
Version 5.1.2600 Service Pack 2 Build 2600

Application name Microsoft Excel
Version 11.0
Build 8146



Has there been changes to the MSN stock quote add-in or mircosoft updates which are interferring with the operation of this add-in?

Is there a limit to how many stock tickers can be updated?

What could I be doing wrong?

Looking to upgrading to Office 2007 - is there a similar add-in & can I continue to my exisiting spreadsheets & templates which use the MSN stock quote. (does the 2002/2003 add-in also work for 2007?)

This add-in is critical to what I do. Any assistance is very much appreciated.

Thanks
LJR