Clarity

When you export a file to excel, PPM uses the old excel extension of .xls.  When exporting a big file recently, 3 different sheets were created to accommodate the line limitation in .xls

If there is a way to change the default to go to the recent version of excel, please let me know.  If not, PPM needs to be updated to account for this.

There has been a fair number of threads on this.

What is your CA PPM version?

See

https://communities.ca.com/message/241817159?commentID=241817159#comment-241817159 

and the TECdocs referenced in it

Some more discussion in

AVP setting for Excel export not applicated 

Remove Export to Excel From Clarity 

Custom portlet - Export to Excel - exports only 25000 

Don't be tempted into using nsql portlets for extreme  data dumping, could crash the app! (Especially if no limit)

Number of options available