This project has moved and is read-only. For the latest updates, please go here.

Creating Hyperlinks in "large" (greater than 41967 links) - corrups xlsx file

May 12, 2013 at 6:41 AM
1) per the max HYPERLINK limit per workbook is 66530.

2) However, if I generate, using Closed XML, any more than 41967 hyperlinks I get errors opening the spreadsheet:
a) "Excel Found unreadable content in <filename>. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes."
b) I click yes, then get a pop up - titled: "Repairs to <filename> with a message:
"Removed Feature: hyperlnks from xl/worksheets/sheet.xml part"
"Click to veiw log files listing repairs: C:\users\<account>\appdata\local\temp\error......xml"

which just shows me the same information above.
(see attachments.)

Any workarounds or positive direction would be greatly appreciated.