When trying to use the "Export to Excel (Data Only)", the exported xls cannot be opened in Excel 365. The following error is seen:
Excel cannot open the file 'FILENAME.xls' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.
Release : 15.7.1
Component : CA PPM APPLICATION
There are no known compatibility issues with Excel Office 365 and the export files. The error being seen is likely related to a security setting implemented within the environment for Microsoft Excel. Please review any Excel policies that have been implemented to ensure none are blocking the ability to open xls files from a downloaded source.