Hyperlinks
 

My spreadsheet somehow got updated with hyper links when i merged a bunch of
worksheets. Most of the cells now have the same hyperlink (opens blank
email). I have cells of text and numbers. How do i either turn off the
hyperlink funtion in this spreadsheet or delete all the hyperlinks?? I tried
the help function - and folowing its suggestion it will work on text cells
but not number cells.

http://www.mvps.org/dmcritchie/excel...#DelHyperlinks

Regards,

Peo Sjoblom

"Maslan" wrote:

My spreadsheet somehow got updated with hyper links when i merged a bunch of
worksheets. Most of the cells now have the same hyperlink (opens blank
email). I have cells of text and numbers. How do i either turn off the
hyperlink funtion in this spreadsheet or delete all the hyperlinks?? I tried
the help function - and folowing its suggestion it will work on text cells
but not number cells.

have you any idea about this?
the option on the right click of the mouse seems to allow to paste
hyperlinks, but this do not really work. Should i try to install a kind of
patch to XL2003,2000

Thanks a lot.



"Peo Sjoblom" wrote:

http://www.mvps.org/dmcritchie/excel...#DelHyperlinks

Regards,

Peo Sjoblom

"Maslan" wrote:

My spreadsheet somehow got updated with hyper links when i merged a bunch of
worksheets. Most of the cells now have the same hyperlink (opens blank
email). I have cells of text and numbers. How do i either turn off the
hyperlink funtion in this spreadsheet or delete all the hyperlinks?? I tried
the help function - and folowing its suggestion it will work on text cells
but not number cells.