When using the feature "Export to Excel", only the first 300 rows are returned

Document ID : KB000039793
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

When using the feature "Export to Excel", only the first 300 rows are returned.

Environment:  

Clarity PPM 13.3, 14.1, 14.2 On-Premise/On-Demand

Cause: 

This limit cannot be changed or disabled. The intention of the option for 'Export to Excel' or 'Export to PowerPoint' is to provide a nicely formatted output.  Therefore, a restriction on the number of rows to be exported into this format is implemented.

Resolution/Workaround:

Use "Export to Excel (Data Only)" instead, as it does not have a 300 row limit.  This option allows the user to export the numerical data into a spreadsheet and then it can be formatted as desired.