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 other columns (with retrieved data from the DB).
Even when no data was found for a certain period, the added columns still had the formulas as content, in the first row of the table.

Now, since Excel 2016, we see strange behaviour....
We use exactly the same version of the reports, same ODBC connector, same DB.
But, when no data is found for a certain period, Excel clears the content of the added column cells...?? In other words, the formulas are gone, wiped away out of the cells...??

Any idea how to fix this??

Thanks in advance,
Peter