How to remove hyperlinks in Excel

Currently I have some hyperlinks in my excel

I want to remove them with the help of UiPath

(ctr+a → right click → Remove Hyperlinks.) → Currently this I am doing manually to remove hyperlinks

How can I do this with the help of Uipath ?

HI @Ishan_Shelke1

You can try with the below depencies , checkout this thread


1 Like

Hi @Ishan_Shelke1 ,

Could you try reading the Excel Sheet as a Datatable and simply writing the Datatable back to Excel and check?

Or simply automate this step itself @Ishan_Shelke1


How do I do this inside Excel ?

Using Typeinto or send hotkey and Click Activities @Ishan_Shelke1

alternative using VBA

  1. paste this code in text file e.g. vba.txt
Function RemoveAllHyperlinks(sheetName As String)
End Function
  1. in excel application scope using invoke VBA activity
    under EntryMethodParameters enter {"SheetName"}
1 Like

Try this steps

Enable Show modern in the filters

  • Excel Process Scope Activity(Property: Show Excel as True)
    • Use Excel File activity (Resize as Maximize)
      • Type into orSend Hotkey Ctrl +a
      • Right click
      • Click on Remove HyperLink

Note : You need to give the necessary conditions to check the menu item panel displayed(Element Exists) and the condition to check whether the Remove Hyperlink is exists or not(Text Exists)


@Ishan_Shelke1 Check this below attached workflow, (9.8 KB)

Hope this may help you :slight_smile:


Getting this error

Take any Excel @Ishan_Shelke1

Goto File-> Option-> Trust Center-> Macro…->Enable all


1 Like

@Ishan_Shelke1 , Please do below changes in excel settings,

For more information check this below link,

Hope this may help you :slight_smile:

1 Like

replace Main with RemoveAllHyperlinks @Ishan_Shelke1

1 Like


1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.