Removing Multiple Hyperlinks (Excel 2003)

Topic

New Reply

I have a client who has a very large spreadsheet with hyperlinks and he would like to remove the hyperlinks all at one time. Is there a way to do this in Excel? Any help will be appreciated. Thank you in advance.

Reply | Quote

Replies

If he would like to turn the hyperlinks into ordinary text values:
– Activate the Visual Basic Editor (Alt+F11)
– Activate the Immediate window (Ctrl+G)
– Type ActiveSheet.Hyperlinks.Delete and press Enter.

I he wants to clear all the cells containing hyperlinks, he’d need a macro.

Reply | Quote

Hi Hans,

I followed your steps on one of my spreadsheets and it didn’t work for me. When I did CTRL + G I couldn’t see that anything happened and I typed the text but the hyperlinks were still active. What am I doing wrong?
Thank you for your help.

Carol

Reply | Quote

Hi Hans,

I spoke too soon. The macro worked very well for me. Thank you again!!
Carol

Reply | Quote