Export to Excel (Data Only) not working with Office365

book

Article ID: 197364

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

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.

Environment

Release : 15.7.1

Component : CA PPM APPLICATION

Resolution

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.