Can't refresh external connection in Excel from Mac

  • Hi all. I have a an Excel workbook that have several External data connections via PowerQuery (actually from built in Data > Get External Data; and slightly modified code in PowerQuery to include variable filenames). The connections are made to .xslx, .xlsm and .csv files. As I read, Microsoft states that it is possible to refresh existing connections on Mac, that are made to these types of files (not sure about .xlsm, but probably that does not matter, as not a single connection refreshes). However, when I try to refresh a query, it throws an error: [Expression.Error] The module named 'ExcelInterop' has been disabled in this context. At first I thought it was connection to Named Table in the current workbook (as I read on Microsoft, it is not supported in Mac), but even when I removed it, the problem persisted. There is not really much information in Google on this issue, so I post it here. Is there a way to actually refresh the data on Mac or no? Thanks to all.

  • Cross-posting Without Telling Us


    Your post does not comply with our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.


    Post a link to any other forums where you have asked the same question.


    Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.


    Read this to understand why we ask you to do this.


    I have added the crosspost reference for you today. Please comply with this and all our rules in the future


    https://www.excelforum.com/exc…on-in-excel-from-mac.html