We have Excel macro enabled XLSM files in Office 2010/2013 which worked 100% fine.
They connect to a MySQL database, and based on start/end date parameters, retrieve data in an Excel worksheet.
In that worksheet we added columns with formulas, for instance, to concatenate values out of certain...