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)
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!
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.
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.
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
I created a new workbook and copied the old one sheet by sheet as is to the new one and the problem went away.
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....
Any idea the process to address this with excel as part of office 365? The formula tab does not offer all of the options you mentioned. Thank you!!