External Data Refresh Failed

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.

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.

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

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!

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.