I have an application that creates a number of reports and saves them as Excel files with the XLSX! save as type and file extension.xlsx. All the reports open in Excel 2016 except one. The one exception can be saved with the EXCEL! SaveAs type and it opens fine but our security settings do not allow me to edit the file and my users will not stand for it anyway.
I have managed to successfully open the file if I do not write any data to the datawindow. I do not see any datawindow properties that relate to this but I may have missed something. I did try the XLSB! save as type but that gave the same problem ans XLSX!
Any suggestions for what I need to change with the datawindow or the way I save it to allow it to save and open?