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.

Yes, this is what I needed! I looked all over for it but couldn't find it. Thank you!

Obviously the problem many of us have is that when stock is delisted or the symbol changes, it can't be updated, so we get the error message at the top of the screen. (Especially now that Excel added auto-refresh options.) I thought I had checked every stock data type, but I kept getting the error message. This helped me find the two I missed.

** Microsoft, if you're listening, you need to update the error checking feature with an option to check the whole workbook, not just the current worksheet. I have about a dozen tabs, so I had to repeatedly go through all the steps above for each sheet. Of course the problematic cells were in the very last tab. :-(

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.

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....