I have a single linked workbook.
When I use Data=>EditLinks=>ChangeSource only some of the links in my workbook change.
Data=>EditLinks then shows two sourcefiles
I can use Edit Replace to successfully change the links.
I have posted here because the problem occurs in Excel. However this is one step of a process that I am automating in VBA so if there are vba workarounds they would be great - (we can move to the vba forum if the answer).
Other information: The linked workbook(s) were all password protected but I have temporarily removed the passwords as part of my problem solving. I have also tried having the new and the old sourcefiles open before I try changing the source.
I don't see any error messages.
Gavin
When I use Data=>EditLinks=>ChangeSource only some of the links in my workbook change.
Data=>EditLinks then shows two sourcefiles
I can use Edit Replace to successfully change the links.
I have posted here because the problem occurs in Excel. However this is one step of a process that I am automating in VBA so if there are vba workarounds they would be great - (we can move to the vba forum if the answer).
Other information: The linked workbook(s) were all password protected but I have temporarily removed the passwords as part of my problem solving. I have also tried having the new and the old sourcefiles open before I try changing the source.
I don't see any error messages.
Gavin