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 http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=1 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.

Regards,
https://www.sugarsync.com/pf/D7819871_76810965_702952
https://www.sugarsync.com/pf/D7819871_76810965_702968
https://www.sugarsync.com/pf/D7819871_76810965_702976