I have a file that contains a list of URLs and which is updated on a daily basis. My problem is, that when I copy/paste URLs in the workbook, they are no longer clickable, instead they are entered in the text format.
- Click on File > Options > Advanced.
- In the right pane, scroll to the "General" Section.
- Click on the "Web Options" button.
- In the dialog that opens, move to the Files tab.
- Check "Updated links on save".