Microsoft.Mashup error message on refresh

Hi. I have a client who keeps encountering the error below when trying to refresh.  The data source is an Excel workbook with macros (.xlsm file).  Not sure what's happening and how to solve because ...