Pasting active links in excel
 

Previously i was able to paste active links and addresses in excel, or format
brush, or double click to activate cells containing links and addresses,
however now this option is not available. I cannot identify the setting that
allows me to change the option back to the way it was.
Thank you if you can help.