I’ve seen many other places on the internet where an item doesn’t show up, requires a plugin, or that the version of Microsoft Office isn’t compatible. This macro solution actually works.
Step 1. Press Alt + F11 to start the Visual Basic Editor.
Step 2. Double click the workbook you are using on the Project Explorer and type the following code:
Step 3. Save your work. Note: if you’re using Excel 2007 or higher it may ask you to save the workbook as .xlsm. If this is only a one-time thing you should just save your workbook “as is.”
Step 4. Run the macro by pressing Alt + F8 or using the menu by View > Macros
Step 5. Select the macro you have made, it should have the name ‘RemoveHyperlinks’.