External Data Refresh Failed

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!

Hi,

I recently started receiving this error as well and was very frustrated that I could not identify the problem cells.

I was able to find the problem stock listings by adding a new stock attribute for the last trade time.   This is one of the attributes that can be brought into Excel.     Doing so showed the ticker that was not updated recently and I was able to fix it.  (The wrong exchange was chosen automatically for the ticker.)

Thought I would share.

My error spawned from delisted stock ETF's

GDAT

GMAN

GDNA

GBUY

I had a day of frustration, reinstalled office, etc..

Ambiguous annoying error ceased once I removed those excel data feeds.

hope this helps!

;)

I had been getting this same error. Uninstalling/Reinstalling just didn't seem like a reasonable solution.

Mine turned out to be a delisted stock. Pretty generic error message which leads you to believe one or more cells are incorrect.

I did this a few days ago too, and it worked for me.

I will give it a go. Thank you. Best, John