External Data Refresh Failed

Go to the Formulas tab. In the Formula Auditing section, click Error Checking. In the lower left of the resulting window, click on Options. At the bottom of the resulting window is a section titled, Error Checking Rules. Deselect everything except, "Cells containing data types that couldn't refresh." Click OK. Click Resume. You should then get a list of the problematic stock data cells.

Thank you!!!!!!!!!!

Your fix completely solved my problem. I have a gigantic multi-sheet workbook and your fix helped me find all the fields that were not updating correcting. Now I can refresh the whole workbook without getting any error. Such a pleasure. Thank you so much! One small, unimportant issue came up though: when I clicked "Resume", as you instructed, I did not get A LIST of problematic cells; instead I was just brought to the next problematic cell. I used this to manually fix each problematic cell. When you clicked "resume", did you really get a list of problematic cells?

This method does work.

You could add a new column to your list of stocks or create a new list altogether in a different area.

Column A   A1 = Stock Ticker

Column B    Price   =A1.[Price]  (to ensure that you have done it correct)

Column C    =A1.[Last trade time]

You will notice that the date and time will be very close for 99% of the stocks, but the one where the tickers are not working.

Good luck

This is a disgrace !

I just updated to last Office 365 (update January 2021) and this issue occurs: "We refreshed some of your data, but we couldn’t refresh all of it because we changed or removed it on our side. For the data we can no longer refresh, we’ve kept the most recent results."

Unable to see which fields are updated and which are not. Thanks a lot MS ! Very unprofessional.

I have a complex and large sheet with Stock Data which is now totally unreliable ???

I just finished my support call with Microsoft. In my case, the issue was fully resolved by uninstalling Office and then reinstalling. The process took about 15 minutes total.

You can try this yourself:

1. Uninstall Office from a PC - Office Support (microsoft.com) <-- use the automated uninstaller in Option 2
2. Reboot the PC
3. Check your "add/remove programs" screen after the automated process has finished, and manually uninstall any additional references to any office apps (Office, Excel, Word, Powerpoint, Outlook, etc.)
4. Potentially reboot the PC again here
5. Reinstall the Office 365 suite after logging in at https://www.office.com/
6. Run office and then tell it to download updates (the installed version doesn't support Stocks data type, so the updates are required)
7. Potentially reboot the PC again here
8. After updating, verify that your file refreshes properly

That fixed the issues on my PC.

Regards,

That's hysterical.  I'm using Office 365 online (ie not a locally installed copy) and have this problem - so it probably means that if only MS would UNINSTALL and REINSTALL their cloud version in Azure it would probably fix the problem for everyone.

Hey MS, are you listening?  This last person solved the problem for you, please follow through.