First thing you have to understand is that you can not use your data scrape activity if the results of it will break your excel, unless you are willing to work on your DataTable before writing it back to excel, if so, tell us the exact content of the column that contains the link that became too big and we help you change it to what i showed you before (would be like this in a for each row):
row("my link column")="=HYPERLINK(row("my link column").ToString, """My Small Text""")"