Change source works on 2013 but not on 2010

[jbcrouigneau]

Hello,

I have a big file that generates some files with only parts of the data from the original file (it works great).
The new file has links to the original file. I wan't to remove these links.

I use the following VBA command

    NewWorkbook.ChangeLink Name:=ThisWorkbook.FullName, NewName:=NewWorkbook.FullName, Type:=xlExcelLinks

It works with Excel 2013, but not with 2010.
The same issue if I make the change manually (Data > Edit links > Change source).
Nothing happens on 2010 when it works on 2013.

Here is a sample :
https://app.box.com/s/kuv450zytwtluvo2trkg

Any idea ?

Best regards

 

[jbcrouigneau]

(To much threads per minute on this forum )
Anyone to help ?

 

[jbcrouigneau]

Last try ?