What to do If Excel Break Links Not Working: When we work with several excel files and use formula to get the work done, we intentionally or unintentionally create links between different files. Normal formula links can be easily broken by using break links option. Popular Articles. On the Data tab, in the Connections group, click Edit Links. Note: The Edit Links command is unavailable if your file does not contain linked information. In the Source list, click the link that you want to break. To select multiple linked objects, hold down the CTRL key, and click each linked object.
Why Do Hyperlinks Stop Working
We are using a script to open all files in a folder, breaks links and save the file into a new location. There are over 50 files in the folder that the script works on perfectly. We have about 10 files that are causing heartburn.
The vba returns an error on this section of code:
When we hit end or debug on the VBA popup and look at the file the links show broken in the file.
What can be causing this?
We don't see any sheets being protected.
Some paths and link names are long, I believe the longest is about 175 characters. Are we exceeding the string variable?
Any suggestions or ideas are appreciated!
The vba returns an error on this section of code:
When we hit end or debug on the VBA popup and look at the file the links show broken in the file.
What can be causing this?
We don't see any sheets being protected.
Some paths and link names are long, I believe the longest is about 175 characters. Are we exceeding the string variable?
Any suggestions or ideas are appreciated!