Aug 02 2020 05:30 AM
My file shows links to two external Excel workbooks which I want to remove. I have followed the instructions to find external references (formulas, Charts, Text Objects, Named Ranges) and can't find them anywhere. I'm using M365, Windows 10. The file attached is anonymised ie not the live one so I could do with knowing where the links are so I can remove them from the live file
Aug 02 2020 06:32 AM
Hello,
After translation, you want to remove the links.
Here is an example with VBA, press the button and all hyperlinks in the workbook are gone.
If you find this helpful, please mark it as Like (click thumbs up) and as "Best Answer", it will be beneficial to more Community members reading here.
Nikolino
I know I don't know anything (Socrates)
Aug 02 2020 08:49 AM
SolutionJan 14 2022 02:29 PM
Aug 02 2020 08:49 AM
Solution