Export to excel (Data only) data is adding hyperlinks

Products

• Clarity PPM On Premise

Issue/Introduction

While exporting to Excel (excel data only), the data is displaying hyperlinks in the Excel file after some amount of rows.

 

Cause

The problem was the limit of hyperlinks by MS Excel being reached.

Environment

Release : 15.7.1

Component : CA PPM PROJECT MANAGEMENT

Resolution

This topic on the communities is reporting the same issue:
https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=756419

The proposed solution was to remove the link on the TSV cells.