Excel - URLs are being entered as plain text

Ask a question




Issue


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.

Solution

  • 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".
  • Click on Ok to validate.

Excel - VBA code for deleting data in row while keeping formulas
VBA - A button to save filename of a document to a cell