Hi,
thanks for your post, and sorry for the trouble.
Unfortunately, directly importing Excel links is not possible, as those have a different format than links on websites (HTML code). You will need to add them as HTML code to your Excel file as well. One quick way to achieve that might be to use a custom Excel macro to convert the original link. Maybe http://ww.wp.xz.cn/support/topic/hyperlinks-in-cells?replies=6#post-4710730 is a good starting point for that.
Regards,
Tobias
Thank you for your prompt reply.
I didn’t explain my problem thoroughly. Let me start over.
I have webpage of HTML links that I’m trying to re-organize by categories.
Right now the links are just listed one after another down the page.
I would like to take that list of unorganized links and display them in a categorized table. (each column alphabetized). The list of links is long and manually moving each link to where it’s new position is very time consuming. I thought that importing the list into Excel then organizing them there, then sorting A-Z would be a shorter process. It worked OK until I the import into Table Press didn’t copy the hyperlinks.
I may be approaching this all wrong and I’m very willing to hear any suggestions.
Thank you.
Hi,
the approach is correct and should be working. However, my answer also applies 🙂 When you save the table in Excel, the HTML information is basically lost, because Excel stores the links in a different format. That’s why you have to restore it as HTML code again.
Regards,
Tobias
