External Data Refresh Failed

Anonymous
2020-12-23T16:53:51+00:00

Had no problems on an existing spreadsheet for months.  I am pulling in stock quotes.  Today I started getting this message:

External Data Refresh Failed  "We refreshed some of your data, but we couldn't refresh all of it because we changed or removed it on our side.  For data we can no longer refresh, we've kept the most recent results.

How do I fix it and how do I identify the cells that are not refreshing?  

Thank you!

Microsoft 365 and Office | Excel | For home | Windows

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.

0 comments

80 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-10-06T15:03:00+00:00

    I did. I'm uncertain as to why you did not, but I did.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-08-28T14:40:57+00:00

    I just recently had this problem. It ended up being related to a Stock ticker that was delisted: USCR.

    Once I finally recalled that USCR had been bought out, I went to the cells that contained the USCR stock market reference, and I noticed that Excel had flagged the cell with a little blue triangle in the corner of the cell. When I hovered my mouse over the cell, it indicated that it was indeed the culprit causing the error message. So I reentered USCR manually, and used Ctrl-Z to undo the auto conversion to a stock ticker, and replace the old stock quote with a manual one. And now I no longer get the errors.

    I would love it if there was a way to have Excel jump to flagged cells.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-08-18T18:42:33+00:00

    I am having the same issue, as well. Same error message, etc. It appears to update all stock prices., anyway, but if it is missing one or two, it's hard to tell which ones. Or if they are the same ones each time.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-07-06T09:29:09+00:00

    Thanks for this feedback. I just double checked all my tickers (again) and I found one which no longer seems to exist (WIlliam Hill Bookmakers). I deleted the row and all's good now. Cheers

    Was this answer helpful?

    0 comments
  5. Anonymous
    2021-07-05T12:02:52+00:00

    Hi guys,

    Let me share my experience with this exact same problem.

    It started to occur last week for me (I have been using the Stocks feature for months now) in the file that we can call file A.

    I first try to run Quick repair, repair Online and install again Office 365. No improvements.

    Then I tried to see (which I should have started with) if the message would still show up in another file B containing the same stocks as in the original.

    It did not.

    I finally came up to notice that 2 specific stocks price were not updating (change% would still be 0 %) after each refresh in file A.

    Then I noticed that one these stocks had a slight different spelling in file B compared to A and the other stock name had a different stock market reference (comes in parenthesis after the stock name in the same cell), this later one may actually come from my wrong doing(?).

    So I copy/pasted names from file B to A and then the Refresh worked fine again, no Warning message anymore.

    So I'm not sure exactly what happened, but I hope my experience can help others (and among them Microsoft teams so that they can come up with a patch or something).

    Was this answer helpful?

    0 comments