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.
I feel for you brother. Unfortunately, I would not hold your breath waiting for anyone one from Mr. softy to help. you. If I am wrong, or you figure it out, please advise.
Just adding on here. I started having this EXACT problem two days ago.
Very interesting that some folks started getting this error message last December, and now many of us are getting the problem here in February. I used Microsoft's automated uninstaller to completely remove Microsoft 365 from my laptop, then reinstalled it. However, this had no effect, and I am still getting the error message every time I click refresh. I've been using my stock spreadsheet for over a year now with no issues until now. My spreadsheet is very small with only ten different stocks, and they are all updating correctly even though I am getting this ridiculous error message saying they couldn't refresh all my data.
It's so frustrating that Microsoft appears unwilling or unable to do anything to fix the problem.
Are you just pulling stock prices, or are you pulling other things like: market capitalization, shares outstanding, etc.
Relatively simple. Stock Name, Ticker and Price. I do have different worksheets that have cells populate from the master sheet that fetches (or is supposed to anyway), the data.
in the simple worksheet that has only tickers and prices, does that document have cells that refer to cells from other documents?
you get the error in all your documents that use stock data?
as an experiment, create a new excel document, and put in just one single stock name, ticker and price. then click refresh. do u get the error?