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
    2020-12-28T21:20:33+00:00

    You can see from their replies that they are not able/willing to address it.  Seems like they feel it is my (and your) problem.  I appreciate you chiming in.  Misery loves company.  If they drop it I guess I'll have to find an out side source for data feeds.    Thanks again.

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  2. Anonymous
    2020-12-29T02:37:29+00:00

    You can see from their replies that they are not able/willing to address it.  Seems like they feel it is my (and your) problem.  I appreciate you chiming in.  Misery loves company.  If they drop it I guess I'll have to find an out side source for data feeds.    Thanks again.

    I successively removed all the individual .attributes I was using, and I still got the error.  Then I successively deleted every security I was tracking, and I still got the error.  Typical MS - they create a feature and then walk away from it.  It's not like all of the attributes ever worked, or that every security could be quoted - so it's now just a little more broken than before.  I suspect that all the data I'm using is actually updating, and those things that never worked now throw an error.  For now I'm ignoring it but it's so annoying.

    Was this answer helpful?

    9 people found this answer helpful.
    0 comments
  3. Anonymous
    2020-12-29T06:28:09+00:00

    Hi JohnKendig1 and FranNelbach,

    Thank you for sharing your experience here.

    Based on your description, it seems that this issue occurs on specific fields and you cannot identify which data is updated and which is stale.

    If so, we have tested it again on our side, and comparing with UTC time, there is no much difference, as shown below:

    Given this situation, on the one hand, since the stock data is provided and updated from the third-party Refinitiv, and this issue only occurs on specific fields, to address your concern about the situation, we’d suggest you report this issue to our related team by clicking Excel > File > Feedback. This feedback will directly go to them so that our related team can hear your voice on this feature directly.

    On the other hand, this issue may be also related to third-party Refinitiv, due to the limited resource on our side, this issue may need to be checked from background. The best way to troubleshoot the issue is to report the issue to the related Team. So we suggest you contact the administrators in your organizations and open a support ticket in the Office 365 admin center via the steps in the articlefor further help. The support team there has the correct escalation channel for this case. This is also the most efficient way in handling this kind of issue.

    Your understanding and patience will be highly appreciated.

    Best Regards,

    Sukie

    Was this answer helpful?

    0 comments
  4. Anonymous
    2021-01-04T17:55:16+00:00

    seems to  me, good customer service would not be to suggest your client to:   "report this issue to our related team" but for YOU to report the issue to the related team, explain and detail to the "related team" the work you have done to try to resolve, and include the client on the correspondence.  Then, if the "related team" assumes responsibility for the problem, consider the matter appropriately transferred.  Your thoughts on this?

    Thank you.

    Was this answer helpful?

    30+ people found this answer helpful.
    0 comments
  5. Anonymous
    2021-01-12T18:17:34+00:00

    I started getting this error today as well. I have submitted a support ticket to look into the issue through Office Admin support channel.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments