When exporting to Excel from Clarity, users that open the file in Excel receive the error:
Problems During Load
Clicking OK, the worksheet still opens.
There is a field that contains an HREF/URL/hyperlink.
Microsoft Excel has a max of 255 characters for this attribute.
Open the file indicated in the Error/Warning provided by Excel, e.g.
The error content will display the reason why it cannot display:
XML Spreadsheet Warning in Table
REASON: String too long
ACTION: Truncating string
Release : 15.8.1
Component : CA PPM SAAS APPLICATION
Check the fields being exported is a URL that is longer than 255 characters.
In the example above, the character count is 280.
This is not a Clarity defect, but a limitation set by Microsoft Excel.
Use Export to CSV as a workaround.