There is no way that I know about to keep the link. However, you can add the links back in Excel by right clicking on the link and select Hyperlink. Then, after the hyperlink has been added, copy and paste it into all the cells that use the same link.
Might be a good one for the Ideas section of the Community.
1 of 1 people found this helpful
If your links are actually formulas, you could (possibly, maybe) reshape the formulas. Save a copy of your sheet, do a find replace of = to '=
Now all of your formulas should be text
Then replace '= with = on the reshaped sheet
Thanks Tracey & Alex. I'll keep trying different things