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-02-24T19:35:06+00:00

    Maybe try putting ticker (e.g. XLON:ITPS) into what you know to be a blank cell as text , select cell , then click STOCKS - if that works it might be a case of reformatting the cells with ?'s in as text, enter the text string (e.g. XLON:ITPS) and the click STOCKS on just that highlighted cell. It's working for me so far fingers crossed.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-02-24T17:34:07+00:00

    Tried this. When I highlighted and clicked STOCKS about half of my stocks came up with ? I re entered each one, They all showed fine. Did it again to make sure I did not miss any and all the ones I fixed where ? marked again. Truly frustrating, but glad it worked for you. Thank you.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-02-23T06:27:08+00:00

    I too started having problems again with STOCK values in excel. the problem showed up today or in the past 1-2 days. I too discovered that it was just one stock causing the problem, so i delete the formula and just typed in a fixed numerical value for that one stock, and that allowed the rets of my worksheet to function. so annoying.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-02-22T19:59:31+00:00

    I am getting this error again on the same workbook... Ugh...

    The uninstall/reuninstall procedure worked before, and I'll probably try it again.

    First I'm going to review the new comments to see if anyone's found any better solutions as the uninstall/reinstall process in total takes ~30 - 45 minutes.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2021-02-11T21:11:24+00:00

    Glad to hear that worked for you.  It's been three days since since I "fixed" my spreadsheet by manually re-entering the stocks, and it is still working fine without throwing any error messages.

    Was this answer helpful?

    0 comments