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.
Worked for me, but of course I had to do this one sheet at a time in a workbook. But found the one pesky delisted stock.
This is a great way to find the faults. I had two stocks which were delisted. I found them both and now I am error free. I have hundreds of queries in my spreadsheet!
You're welcome now if we can just get MSFT to figure it out.
I'd also like to get rid of the error message just because a formula is different. It's a legitimate formula, not an error. Possibly they could breakout formula differences vs errors.
I had a whole page of calculations where I calculated average price and had to ignore the error on every one of them. PITA!!
But it turns out you were correct (in my case, anyway). I had a sheet with shares I've sold and in that was one (John Laing) which has since been taken over, so has disappeared. Once I removed its 'ticker' the error messages stopped.
Still infuriating that Excel is unable to identify where the error originates from and generates a whole series of meaningless information (for example that the error is due to cell XY because it is not locked and so could inadvertently be changed).
But thanks for sticking with the problem and identifying a solution.
It's a good point about shares which have been sold creating a legacy issue but let's imagine this is the cause - the fact that Excel then says there is an error but not only fails to identify where but when 'interrogated' using the error checking function actually identifies a whole series of cells which are unrelated to the actual cause is itself a bug.