Shut off web links?
 

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

Shut off web links?
 

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 wrote:

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

Shut off web links?
 

Thanks. There are about 200 names on the list.

Bob

"Dave Peterson" wrote in message
...
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 wrote:

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