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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2021-11-14T21:23:50+00:00

    I all of a sudden started getting this message as well every time a data refresh is done. There were no code or data changed so it is obviously a Microsoft or Refinitiv problem......please fix ASAP - it is very annoying....

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-11-14T22:25:51+00:00

    I created a new workbook and copied the old one sheet by sheet as is to the new one and the problem went away.

    Was this answer helpful?

    0 comments
  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  4. Anonymous
    2021-11-17T16:22:33+00:00

    Thanks, this approach helped me to identify the root cause (a stock that has been delisted). Too bad that Excel does not provide better, easy to understand error information.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2021-12-08T20:36:02+00:00

    Go to the Formulas tab. In the Formula Auditing section, click Error Checking. In the lower left of the resulting window, click on Options. At the bottom of the resulting window is a section titled, Error Checking Rules. Deselect everything except, "Cells containing data types that couldn't refresh." Click OK. Click Resume. You should then get a list of the problematic stock data cells.

    Yes, this is what I needed! I looked all over for it but couldn't find it. Thank you!

    Obviously the problem many of us have is that when stock is delisted or the symbol changes, it can't be updated, so we get the error message at the top of the screen. (Especially now that Excel added auto-refresh options.) I thought I had checked every stock data type, but I kept getting the error message. This helped me find the two I missed.

    ** Microsoft, if you're listening, you need to update the error checking feature with an option to check the whole workbook, not just the current worksheet. I have about a dozen tabs, so I had to repeatedly go through all the steps above for each sheet. Of course the problematic cells were in the very last tab. :-(

    Was this answer helpful?

    0 comments