This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I installed the MSN Money Stock Quotes add-in in Excel 2013 and it was working perfectly yesterday, but for some reason it has stopped updating quotes today. The selection for "Update Quotes" from the add-in toolbar is not active. However, the "Insert Stock Quotes" button is active and when I press it, I get the Stock Quotes dialog box. It will insert the formula for the quotes in the spreadsheet, but it does not provide an up-to-date quote. I would appreciate any help on this, as this add-in is a big time-saver for me. I did notice that my software was automatically updated yesterday. (I believe that it was a Windows update, but I am not 100% sure.) I do not know whether this might have something to do with the change, since, as I said, the add-in was working yesteday.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Did you ever get your MS Money to work? I had the same problem just yesterday. The "Update Quotes" tab wouldn't do anything, but the "Insert Stock Quotes" tab would. I went ahead and re-inserted all the stock symbols by highlilighting my entire selection and everything updated and is working fine again.
http://www.technitya.com/content/stock-quotes-excel
I am using this one. Seems to work great so far.
Looks like Microsoft needs to start laying off some of their employees that do their software debugging before they release it.
Yes, and Microsoft also needs to show the customer more courtesy by documenting changes that affect their customers, and announcing those changes well in advance.
I am hoping that manatee_736 is still following this thread and will provide the link to the post that described the solution.
Looks like Microsoft needs to start laying off some of their employees that do their software debugging before they release it.
Per above solution:
I have tried the third parameter as "US", "USA", and "NYSE" (as in =MSNStockQuote($A2,"Last Price","US"). All failed on selected tickers I had in my spreadsheet returning all dashes instead of the last price. I also tried changing the ticker symbol randomly to ones I was not actually interested in just to see if the response was the same and many tickers do work just fine (like "MSFT" or "YHOO"), just not with the two tickers I was looking for (like "DNKN" or "BP").
By accident, I happened to change the third paramter to "*USA" (note the asterisk before USA) and it suddenly worked for "DNKN" and "BP". It also works using "*US" (again with the asterisk before US).
I have been using MSN Stock Quotes for years with no problems, first with Excel 2002, now with Excel 2007. This all just started around the end of June, 2013.