Clarity PPM: Why warning message box pop up when opening an Excel exported file?

book

Article ID: 141169

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The following warning message box is displayed when open a excel file from "Export to Excel (data only)" function.
Why is this message box pop up?



 

Cause

"Export to Excel (data only)" function uses XML Spread Sheet format and xls file extension to download portlet as excel file.
When open the file with Excel, Excel understands it is XML Spread sheet but its extension is not xml, so Excel will pop up dialog to alert users.

Environment

Release : 15.6.x, 15.7

Component : CA PPM APPLICATION

Resolution

If it is clarified that the file is from "Export to Excel (data only)" function, please click 'Yes' button.
Excel will be able to open it.

One of the ways to avoid this warning message box, manually change extension from xls to xml.

Attachments