Activate hyperlinks in Excel 2010 spreadsheet

Question

Is there a way to select and activate all the hyperlinks in a given column on an Excel spreadsheet? When I double click them, nothing happens , but if I leave the field and then re-select it, the hyperlink goes to the pdf file well.  Is there any way to get the links to be active without selecting and unselecting each one? I tried the format painter and it changes the color of the link to blue but doesn't make it go to the form.

Thanks for the help!!

Ken K. - 2191

Answer 1

When you export the Excel from Access, I believe your so called "hyperlink" is just a text, and then it turned to hyperlink when you click on it, you can use VBA to add back the hyperlink

Sub Macro1()

    convtCol = "A"

    For i = 1 To ActiveSheet.Range(convtCol & Rows.Count).End(xlUp).Row

        ActiveSheet.Hyperlinks.Add Anchor:=Range(convtCol & i), Address:=Range(convtCol & i).Value, TextToDisplay:=Range(convtCol & i).Value

    Next i

End Sub

Answer 2

Worked perfectly!!  Thanks again for all of the help!!!

Happy 2015!

Ken K. - 2191

Answer 3

Thanks for the help!  I haven't done much at all with VBA, but I'm looking forward to trying it!!

Have a great day!

Ken K. - 2191

Answer 4

Hi Nayana

Thanks for getting back to me so quickly!!  I exported an Access 2010 file to Excel and the Excel file includes a field that contains hyperlinks to all of our forms in PDF format.  If I single click on the cell that contains the pdf file name, nothing happens, but when I double click the cell with the name of the pdf form and then move to another cell when I return to the cell that was double clicked, the link has turned blue and is active.  I just wanted to see if anyone knew a way to activate the links without actually going into each cell and double clicking it.

Thanks for the help!!  Happy 2015!!!!

Ken K. - 2191

Answer 5

Hi Ken,

Thank you for posting in Microsoft Excel Community.

To help you better, we need few details about the issue.

1. Could you provide us the exact steps on how is hyperlink applied to the columns in the Excel file.
2. Does each cell is hyperlinked to different file?
3. Does the issue occurs with specific file or with all the files?

Provide us the detailed information about the issue which will help us to analyze and assist you in better way.

Thank you.