Hyperlinks problem

K

Kathy K

In some formulas in a worksheet, Excel has changed a formula into a hyperlink
with a "mailto" address of the cell location. This does not happen all of
the time but can happen with a simple formula dividing the contents of one
cell by another. It generally will happen with a series of cells next to
each other. The only way I can remove the hyperlink is to go to each cell
and "remove hyperlink."
 
D

Dave Peterson

Are you a former Lotus 123 user?

If you are, try using the = (equal sign) instead of the @ sign to indicate a
function. (I'm guessing that something looks like an email address after you do
whatever you do.)

And if you want to get rid of hyperlinks from a selection (ctrl-a (twice in
xl2003) to select the whole worksheet), try this:

hit alt-f11 (to get to the VBE)
hit ctrl-g (to see the immediate window)

type this and hit enter
selection.hyperlinks.delete
 
Top