Can't create multiple hyperlinks from URL in Excel 14 to open web pages

kleinermuk

New Member
Joined
Nov 3, 2020
Messages
23
Office Version
  1. 2010
Platform
  1. Windows
I can create a hyperlink by double clicking on the field with URL and then Enter button. That method works fine for me, but with hundreds of URL's it will take me forever to create hyperlinks one by one.



I tried to create hyperlinks by highlighting the whole column and clicking Hyperlink button on Toolbar which would make all records in the column blue, but when clicking on each, the Error Message would appear: "Unable to open www.test.com. Can not locate the Internet Server or Proxy Server"



I also tried a different method by creating a new column and inserting formula like =HYPERLINK(J7), which also would create a hyperlink, but when I click on that newly created hyperlink, the Error message would say: "Can not open specified file".



Any idea why first manual method is working and the rest of the methods don't and also on how to fix it, so I won't have to do it manually for a few days?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

kleinermuk

New Member
Joined
Nov 3, 2020
Messages
23
Office Version
  1. 2010
Platform
  1. Windows
Something must be wrong with my version of Excel then.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,241
Messages
5,576,906
Members
412,753
Latest member
Coach_Olson
Top