Unable to refresh external data source on Mac for a Excel created on Windows

%3CLINGO-SUB%20id%3D%22lingo-sub-2347571%22%20slang%3D%22en-US%22%3EUnable%20to%20refresh%20external%20data%20source%20on%20Mac%20for%20a%20Excel%20created%20on%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2347571%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20-%20I'm%20trying%20to%20refresh%20data%20from%20an%20external%20data%20source%20(text%20file)%20on%20Excel%202016%20Mac.%20The%20Excel%20that%20I'm%20trying%20to%20refresh%20data%20for%20was%20created%20on%20a%20Windows%20laptop.%20The%20text%20file%20data%20source%20connections%20were%20configured%20on%20Windows%20laptop%20previously%2C%20the%20external%20data%20text%20file%20exists%2C%20however%2C%20I'm%20not%20able%20to%20refresh%20data%20on%20Mac.%20Can%20you%20please%20help%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3CBR%20%2F%3EVK%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2347571%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2347685%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20refresh%20external%20data%20source%20on%20Mac%20for%20a%20Excel%20created%20on%20Windows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2347685%22%20slang%3D%22en-US%22%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1051632%22%20target%3D%22_blank%22%3E%40Vkanthich%3C%2FA%3E%20%2C%3CBR%20%2F%3EI'm%20not%20sure%20if%20I%20understood%20you%20right%2C%20but%20is%20it%20possible%20that%20u%20have%20linked%20your%20external%20data%20different%20than%20Windows%2C%20so%20Mac%20is%20unable%20to%20refresh%20it%3F%3CBR%20%2F%3EBest%20regards%3CBR%20%2F%3ESchnittlauch%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi - I'm trying to refresh data from an external data source (text file) on Excel 2016 Mac. The Excel that I'm trying to refresh data for was created on a Windows laptop. The text file data source connections were configured on Windows laptop previously, the external data text file exists, however, I'm not able to refresh data on Mac. Can you please help? 

 

Thank you
VK

2 Replies
Hi @Vkanthich ,
I'm not sure if I understood you right, but is it possible that u have linked your external data different than Windows, so Mac is unable to refresh it?
Best regards
Schnittlauch

@Vkanthich I suspect that the connection was made using Power Query. If so, then you can not refresh that particular connection on a Mac. More about what you can refresh on a Mac in the link below.

https://support.microsoft.com/en-us/office/use-power-query-in-excel-for-mac-7b2f337d-e7d2-4fdf-bf00-...