search cancel

Clarity PPM: Cannot Export to XLS from Resource/Role Allocations Page


Article ID: 134007


Updated On:


Clarity PPM On Premise


Export to Excel does not work from the Resource/Role Allocations - Detail page when getting to it by clicking on the 'Resource Allocations' icon on the Team -Detail tab. An error is thrown in Excel and a blank file is generated. 

Steps to Reproduce:

1. Go to Home - Projects

2. Open any project with a team

3. Go to the Team tab

4. On the 'Team - Detail' page, click on the 'Resource Allocation' icon for any role or resource

5. This takes users to the Resource/Role Allocations (Detail) page, click on Options - Export to Excel (Data Only)

Expected Results: The 'Resource_Allocations_-Details.xls' file that is generated opens and displays the data.

Actual Results: The 'Resource_Allocations_-Details.xls' file that is generated throws an error and does not display any data.

Error in Excel Log:

XML ERROR in Worksheet Setting

REASON: Bad Value

FILE: C:\Users\<user>\Downloads\Resource_Allocations_-_Detail.xls

GROUP: Worksheet

TAG: Table

ATTRIB: ExpandedColumnCount



Release : Clarity PPM 14.3 - 15.6.1

Component : CA PPM STUDIO


Caused by DE49964


DE49964 is currently under review by our engineering team for a resolution. 

Workaround: Navigate to the Allocations Detail page directly by going to Home - Resources, select a resource/role - Allocations tab - Detail to successfully print the list view from here.