Overview:
When a Vault report is exported using the Export to Excel action, the warning message shown below is generated. After bypassing the warning message, the file opens. However, the hyperlinks are not functional.
Root Cause:
This is a known limitation of Microsoft Excel. The Excel file can have no more than 65,500 hyperlinks. A hyperlink is added for the Document Name and Document Number columns, therefore, the sum of the hyperlinks must be within this limit.
Excel removes all the hyperlinks in order to open the file when it is over the limit, but the contents of the file should be the same.
Solution:
Use the following suggested workarounds for this issue:
- Export to CSV or TXT; the links are included as plain text in a separate column
- Add filters to the report to reduce the number of records to reduce the number of hyperlinks in the Excel file
Related Documentation:
Vault Exporting Reports Documentation: Limits for Excel Export