Excel - URLs are being entered as plain text

May 2017





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.

Related


Published by deri58. Latest update on November 7, 2012 at 10:13 AM by deri58.
This document, titled "Excel - URLs are being entered as plain text," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).