Troubleshooting
Problem
When exporting report to Excel, hyperlinks in large lists do not export successfully and message is displayed:
We found a problem with some content in 'content'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.
When selecting Yes, report opens in Excel but hyperlinks do not work
Cause
Diagnosing The Problem
Hyperlinks are valid after manually correcting them.
Resolving The Problem
Refer to the following Microsoft article for information:
Hyperlinks are removed or invalid after you sort cells that contain these hyperlinks in Excel
To help avoid this issue in Cognos Analytics the following parameter can be implemented to display all rows on a single Excel sheet.
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS
Related Information
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl5QAAS","label":"Reporting-\u003EOutput formats and rendering"}],"ARM Case Number":"TS008024575","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
Was this topic helpful?
Document Information
Modified date:
05 January 2022
UID
swg22013999