Shut off web links?

[Bob Newman]

Excel 2007
I copied over a list of names from a web page. On the web page these names
were formated so that if you clicked on a name a new web page would open
with a biography of that person. After copying the list into Excel whenever
I click on a cell containing a person's name a web browser page still pops
up with a biography of that person. How do I turn off this feature in
Excel? I just want to treat this as any other spreadsheet cell and not be
taken to my browser. I have formatted the cells so they no longer look like
links (no blue letters or underlining). They now look like normal cell but
still do not act like them. Suggestions please.

Thanks in advance... Bob

 

[Dave Peterson]

You can select the cell with the name (and hyperlink) and hit ctrl-k (this
option is Insert|Hyperlink in xl2003 menus and in the Insert Tab of the ribbon
(Links group)).

And remove each hyperlink one at a time.

Another way if you have more than a couple.

Select the range to fix (all the cells is ok if you want)
Hit alt-f11 to get to the VBE (where macros live)
Hit ctrl-g to see the immediate window
type this and hit enter:
Selection.hyperlinks.delete

then hit alt-f11 to get back to excel and see if it worked.

 

[Bob Newman]

Thanks. There are about 200 names on the list.

Bob