Refresh All on OS X Excel 2016 " data range "ExternalData_1" failed to refresh

Hello all

Im testing my workbook that was designed on Windows 7 on my OS X Sierra laptop.

When I refresh all data, I get an error:

The following data range failed to refresh:
• ExternalData_1
Continue to refresh all?

I cant figure out how to track down this range/connection/??? any tips?

TIA
Randall

Data Tab, Connections next to refresh all should have a listing of all your data from whatever source (external, web, text, etc) just go into that and simply remove it or restore the link to the proper address (if you know it)

Thank you for the tip- Data-Queries & Connections->Connections states I have NO connections!

anywhere else I can look?

Randall

Are there any ranges within the worksheet itself? Should be able to look in the name manager in the formula tab...in lieu of nothing being there, you can try to save it with a different name (I had this issue before but don't remember how I fixed it.)

There isnt any connections/names that arent external. Ill keep digging...