Fastest way to not have live links

[kevs]

The annoying feature that make e mails and weblinks live, what is fastest
way to clear them from a full excel worksheet, and then get rid of that
future permanently. Thanks!

Kevs


OS 10.4.7
Office 2004

 

[JE McGimpsey]

The annoying feature that make e mails and weblinks live, what is fastest
way to clear them from a full excel worksheet, and then get rid of that
future permanently. Thanks!

See

http://www.mcgimpsey.com/excel/nohyperlinks.html

and

http://www.mcgimpsey.com/excel/nohyperlinks2.html

 

[Harvey Waxman]

The annoying feature that make e mails and weblinks live, what is fastest
way to clear them from a full excel worksheet, and then get rid of that
future permanently. Thanks!

Kevs


OS 10.4.7
Office 2004

There is a great macro supplied by Mr. McGimpsey that is perfect for removing
them. I have also found that if you undo (cmd-Z) immediately after entering an
address you will remove the link but keep the address.

 

[kevs]

See

http://www.mcgimpsey.com/excel/nohyperlinks.html

and

http://www.mcgimpsey.com/excel/nohyperlinks2.html

Thanks JE:
Unlike with Word, there is not even a preference in Excel to disable the
feature?




OS 10.4.7
Office 2004

 

[JE McGimpsey]

Unlike with Word, there is not even a preference in Excel to disable the
feature?

correct.