When trying to inspect problematic hyperlinks in a binder. Here is one method you can try:
Save a local copy of the binder.
Open the saved local copy of the binder and disable the Active workpapers addin.
Go to Developer Tools > click View Code. In the VBA editor, go to Insert > Module.
Paste the following code into the module and run it:
---------------------------------------------------------------------
Sub ListHyperlinks()
Dim ws As Worksheet
Dim hl As Hyperlink
Dim outputWs As Worksheet
Dim rowCount As Long
' Create a new sheet for the list of hyperlinks
Set outputWs = ThisWorkbook.Sheets.Add
outputWs.Name = "Hyperlinks List"
' Add headers
outputWs.Cells(1, 1).Value = "Sheet"
outputWs.Cells(1, 2).Value = "Cell"
outputWs.Cells(1, 3).Value = "Hyperlink Address"
rowCount = 2
' Loop through each worksheet and list hyperlinks
For Each ws In ThisWorkbook.Worksheets
For Each hl In ws.Hyperlinks
outputWs.Cells(rowCount, 1).Value = ws.Name
outputWs.Cells(rowCount, 2).Value = hl.Parent.Address
outputWs.Cells(rowCount, 3).Value = hl.Address
rowCount = rowCount + 1
Next hl
Next ws
MsgBox "Hyperlinks listed in new sheet!"
End Sub
-------------------------------------------------------------------
Once you run the code, a new sheet named 'Hyperlinks List' will be created in the excel workbook which can be copied to a new excel file. This sheet will display all the hyperlinks from the binder, excluding hidden sheets.