VBA Break Link Loop not working

[kyddrivers]

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:

For Each currentLink In linkSources
currentWorkbook.BreakLink currentLink, xlLinkTypeExcelLinks
           Next currentLink

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!

 

[kyddrivers]

It does let us break the links manually.